explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WPFw

Settings
# exclusive inclusive rows x rows loops node
1. 42.723 11,531.462 ↓ 2.4 95,915 1

Sort (cost=662,792.200..662,892.200 rows=40,000 width=38) (actual time=11,525.040..11,531.462 rows=95,915 loops=1)

  • Sort Key: foxtrot.golf_romeo
  • Sort Method: quicksort Memory: 10566kB
2. 1,019.017 11,488.739 ↓ 2.4 95,915 1

HashAggregate (cost=659,234.650..659,734.650 rows=40,000 width=38) (actual time=11,459.950..11,488.739 rows=95,915 loops=1)

  • Group Key: foxtrot.golf_romeo, five((((quebec(foxtrot.tango_lima) zulu (?) < (foxtrot.tango_lima - 'echo'::interval))) OR NULL::boolean)) zulu (?)
3. 1,718.288 10,469.722 ↓ 1.6 4,235,706 1

WindowAgg (cost=450,513.670..591,905.300 rows=2,693,174 width=22) (actual time=6,270.538..10,469.722 rows=4,235,706 loops=1)

4. 1,604.203 8,751.434 ↓ 1.6 4,235,706 1

WindowAgg (cost=450,513.670..517,843.020 rows=2,693,174 width=123) (actual time=6,270.506..8,751.434 rows=4,235,706 loops=1)

5. 4,671.843 7,147.231 ↓ 1.6 4,235,706 1

Sort (cost=450,513.670..457,246.600 rows=2,693,174 width=14) (actual time=6,270.383..7,147.231 rows=4,235,706 loops=1)

  • Sort Key: foxtrot.golf_romeo, foxtrot.tango_lima
  • Sort Method: quicksort Memory: 395157kB
6. 197.865 2,475.388 ↓ 1.6 4,235,706 1

Append (cost=0.000..162,870.890 rows=2,693,174 width=14) (actual time=0.034..2,475.388 rows=4,235,706 loops=1)

7. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on foxtrot (cost=0.000..0.000 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tango_lima >= 'two'::timestamp with time zone) AND (tango_lima <= 'golf_tango'::timestamp with time zone))
8. 2,277.521 2,277.521 ↓ 1.6 4,235,706 1

Index Scan using november on tango_tango (cost=0.570..162,870.890 rows=2,693,173 width=14) (actual time=0.031..2,277.521 rows=4,235,706 loops=1)

  • Index Cond: ((tango_lima >= 'two'::timestamp with time zone) AND (tango_lima <= 'golf_tango'::timestamp with time zone))