explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Bb6 : SQL 1: (SO: http://stackoverflow.com/q/29555116/1082673)

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3,265,083.809 ↑ 1.0 1 1

Aggregate (cost=476,413,999.300..476,413,999.310 rows=1 width=13) (actual time=3,265,083.808..3,265,083.809 rows=1 loops=1)

  • Index Cond: ((seven >= 'papa'::timestamp without time zone) AND (seven <= 'tango_sierra'::timestamp without time zone))
  • Filter: (NOT (delta 1))
  • Rows Removed by Filter: 8206
  • Filter: (seven < 'papa'::timestamp without time zone)
  • Rows Removed by Filter: 34691
2. 3,264,759.989 3,264,759.989 ↓ 1.4 22,241 1

Index Scan using tango_uniform on bravo (cost=0.420..476,413,960.490 rows=15,524 width=13) (actual time=361.686..3,264,759.989 rows=22,241 loops=1)

3.          

SubPlan (for Aggregate)

4. 1,470,437.865 1,470,437.865 ↑ 1.1 573,493 30,447

Materialize (cost=0.000..29,092.590 rows=638,861 width=13) (actual time=0.003..48.295 rows=573,493 loops=30,447)

5. 183.477 183.477 ↓ 1.0 641,412 1

Seq Scan on bravo juliet (cost=0.000..22,778.290 rows=638,861 width=13) (actual time=1.125..183.477 rows=641,412 loops=1)