explain-analyze.info

Time	Node
Node (ms)	Percent
2703.657	100.00%	¶	`Merge Join (cost=373.97..60903.97 rows=3125000 width=279) (actual time=2662.859..2703.657 rows=4606 loops=1) Merge Cond: (br.submission_id = ct.submission_id)`
2558.405	94.63%	¶	`-> Merge Join (cost=311.64..12404.14 rows=625000 width=283) (actual time=2524.756..2558.405 rows=4606 loops=1) Merge Cond: (br.submission_id = ct.submission_id)`
1515.997	56.07%	¶	`-> Merge Join (cost=249.32..2654.32 rows=125000 width=167) (actual time=1492.915..1515.997 rows=4606 loops=1) Merge Cond: (br.submission_id = ct.submission_id)`
604.269	22.35%	¶	`-> Merge Join (cost=186.99..654.49 rows=25000 width=71) (actual time=590.132..604.269 rows=4606 loops=1) Merge Cond: (br.submission_id = ct.submission_id)`
545.351	20.17%	¶	`-> Merge Join (cost=124.66..204.66 rows=5000 width=58) (actual time=537.677..545.351 rows=4606 loops=1) Merge Cond: (br.submission_id = ct.submission_id)`
464.230	17.17%	¶	`-> Sort (cost=62.33..64.83 rows=1000 width=22) (actual time=463.484..464.230 rows=4606 loops=1) Sort Key: br.submission_id Sort Method: quicksort Memory: 552kB`
460.692	17.04%	¶	`-> Function Scan on crosstab br (cost=0.0..12.5 rows=1000 width=22) (actual time=459.001..460.692 rows=4606 loops=1)`
75.040	2.78%	¶	`-> Sort (cost=62.33..64.83 rows=1000 width=36) (actual time=74.179..75.040 rows=4606 loops=1) Sort Key: ct.submission_id Sort Method: quicksort Memory: 552kB`
72.851	2.69%	¶	`-> Function Scan on crosstab ct (cost=0.0..12.5 rows=1000 width=36) (actual time=71.977..72.851 rows=4606 loops=1)`
53.209	1.97%	¶	`-> Sort (cost=62.33..64.83 rows=1000 width=13) (actual time=52.444..53.209 rows=4606 loops=1) Sort Key: ct.submission_id Sort Method: quicksort Memory: 408kB`
50.747	1.88%	¶	`-> Function Scan on crosstab ct (cost=0.0..12.5 rows=1000 width=13) (actual time=49.370..50.747 rows=4606 loops=1)`
903.466	33.42%	¶	`-> Sort (cost=62.33..64.83 rows=1000 width=96) (actual time=902.768..903.466 rows=4606 loops=1) Sort Key: ct.submission_id Sort Method: quicksort Memory: 840kB`
898.664	33.24%	¶	`-> Function Scan on crosstab ct (cost=0.0..12.5 rows=1000 width=96) (actual time=896.326..898.664 rows=4606 loops=1)`
1032.492	38.19%	¶	`-> Sort (cost=62.33..64.83 rows=1000 width=116) (actual time=1031.825..1032.492 rows=4606 loops=1) Sort Key: ct.submission_id Sort Method: quicksort Memory: 858kB`
1026.315	37.96%	¶	`-> Function Scan on crosstab ct (cost=0.0..12.5 rows=1000 width=116) (actual time=1023.478..1026.315 rows=4606 loops=1)`
138.734	5.13%	¶	`-> Sort (cost=62.33..64.83 rows=1000 width=16) (actual time=138.090..138.734 rows=4606 loops=1) Sort Key: ct.submission_id Sort Method: quicksort Memory: 408kB`
136.793	5.06%	¶	`-> Function Scan on crosstab ct (cost=0.0..12.5 rows=1000 width=16) (actual time=135.762..136.793 rows=4606 loops=1)`

2703.657

100.00%

 Merge Join (cost=373.97..60903.97 rows=3125000 width=279) (actual time=2662.859..2703.657 rows=4606 loops=1)
  Merge Cond: (br.submission_id = ct.submission_id)

2558.405

94.63%

¶

  -> Merge Join (cost=311.64..12404.14 rows=625000 width=283) (actual time=2524.756..2558.405 rows=4606 loops=1)
        Merge Cond: (br.submission_id = ct.submission_id)

1515.997

56.07%

¶

        -> Merge Join (cost=249.32..2654.32 rows=125000 width=167) (actual time=1492.915..1515.997 rows=4606 loops=1)
              Merge Cond: (br.submission_id = ct.submission_id)

604.269

22.35%

¶

              -> Merge Join (cost=186.99..654.49 rows=25000 width=71) (actual time=590.132..604.269 rows=4606 loops=1)
                    Merge Cond: (br.submission_id = ct.submission_id)

545.351

20.17%

¶

                    -> Merge Join (cost=124.66..204.66 rows=5000 width=58) (actual time=537.677..545.351 rows=4606 loops=1)
                          Merge Cond: (br.submission_id = ct.submission_id)

464.230

17.17%

¶

                          -> Sort (cost=62.33..64.83 rows=1000 width=22) (actual time=463.484..464.230 rows=4606 loops=1)
                                Sort Key: br.submission_id
                                Sort Method:  quicksort  Memory: 552kB

460.692

17.04%

¶

                                -> Function Scan on crosstab br (cost=0.0..12.5 rows=1000 width=22) (actual time=459.001..460.692 rows=4606 loops=1)

75.040

2.78%

¶

                          -> Sort (cost=62.33..64.83 rows=1000 width=36) (actual time=74.179..75.040 rows=4606 loops=1)
                                Sort Key: ct.submission_id
                                Sort Method:  quicksort  Memory: 552kB

72.851

2.69%

¶

                                -> Function Scan on crosstab ct (cost=0.0..12.5 rows=1000 width=36) (actual time=71.977..72.851 rows=4606 loops=1)

53.209

1.97%

¶

                    -> Sort (cost=62.33..64.83 rows=1000 width=13) (actual time=52.444..53.209 rows=4606 loops=1)
                          Sort Key: ct.submission_id
                          Sort Method:  quicksort  Memory: 408kB

50.747

1.88%

¶

                          -> Function Scan on crosstab ct (cost=0.0..12.5 rows=1000 width=13) (actual time=49.370..50.747 rows=4606 loops=1)

903.466

33.42%

¶

              -> Sort (cost=62.33..64.83 rows=1000 width=96) (actual time=902.768..903.466 rows=4606 loops=1)
                    Sort Key: ct.submission_id
                    Sort Method:  quicksort  Memory: 840kB

898.664

33.24%

¶

                    -> Function Scan on crosstab ct (cost=0.0..12.5 rows=1000 width=96) (actual time=896.326..898.664 rows=4606 loops=1)

1032.492

38.19%

¶

        -> Sort (cost=62.33..64.83 rows=1000 width=116) (actual time=1031.825..1032.492 rows=4606 loops=1)
              Sort Key: ct.submission_id
              Sort Method:  quicksort  Memory: 858kB

1026.315

37.96%

¶

              -> Function Scan on crosstab ct (cost=0.0..12.5 rows=1000 width=116) (actual time=1023.478..1026.315 rows=4606 loops=1)

138.734

5.13%

¶

  -> Sort (cost=62.33..64.83 rows=1000 width=16) (actual time=138.090..138.734 rows=4606 loops=1)
        Sort Key: ct.submission_id
        Sort Method:  quicksort  Memory: 408kB

136.793

5.06%

¶

        -> Function Scan on crosstab ct (cost=0.0..12.5 rows=1000 width=16) (actual time=135.762..136.793 rows=4606 loops=1)

fast ct