explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tm7o

Settings
# exclusive inclusive rows x rows loops node
1. 152.365 21,419.264 ↓ 1.2 13,559 1

Sort (cost=4,042,307.880..4,042,336.170 rows=11,313 width=92) (actual time=21,407.472..21,419.264 rows=13,559 loops=1)

  • Sort Key: four_delta.tango_victor, four_delta.seven
  • Sort Method: quicksort Memory: 2,291kB
2.          

CTE four_uniform

3. 13.518 1,074.616 ↓ 1.2 13,559 1

Sort (cost=201,631.170..201,659.450 rows=11,313 width=84) (actual time=1,071.547..1,074.616 rows=13,559 loops=1)

  • Sort Key: two.seven DESC
  • Sort Method: quicksort Memory: 1,444kB
4. 1,061.098 1,061.098 ↓ 1.2 13,559 1

Seq Scan on two (cost=0.000..200,869.490 rows=11,313 width=84) (actual time=74.734..1,061.098 rows=13,559 loops=1)

  • Filter: (seven >= 'four_two'::timestamp without time zone)
  • Rows Removed by Filter: 638,757
5. 1,091.107 21,266.899 ↓ 1.2 13,559 1

CTE Scan on four_uniform four_delta (cost=0.000..3,839,886.740 rows=11,313 width=92) (actual time=1,080.297..21,266.899 rows=13,559 loops=1)

6.          

SubPlan (for CTE Scan)

7. 27.118 20,175.792 ↑ 1.0 1 13,559

Aggregate (cost=339.390..339.400 rows=1 width=8) (actual time=1.487..1.488 rows=1 loops=13,559)

8. 20,148.674 20,148.674 ↓ 0.0 0 13,559

CTE Scan on four_uniform tango_kilo (cost=0.000..339.390 rows=1 width=0) (actual time=1.466..1.486 rows=0 loops=13,559)

  • Filter: ((seven < four_delta.seven) AND (four_delta.tango_victor = tango_victor) AND (seven > (four_delta.seven - 'foxtrot'::interval)))
  • Rows Removed by Filter: 13,559
Planning time : 0.192 ms
Execution time : 21,422.477 ms