explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wtbi

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.564 ↑ 1.0 1 1

Result (cost=175.86..175.87 rows=1 width=0) (actual time=0.564..0.564 rows=1 loops=1)

2.          

Initplan (forResult)

3. 0.001 0.560 ↑ 1.0 1 1

Limit (cost=0.56..175.86 rows=1 width=8) (actual time=0.560..0.560 rows=1 loops=1)

4. 0.559 0.559 ↑ 12,017.0 1 1

Index Scan using driver_events_raw_index02 on driver_events_raw (cost=0.56..2,106,539.38 rows=12,017 width=8) (actual time=0.559..0.559 rows=1 loops=1)

  • Index Cond: (datetime_from IS NOT NULL)
  • Filter: ((driver)::text = 'UAD00000700820'::text)
  • Rows Removed by Filter: 292
Planning time : 0.276 ms
Execution time : 0.598 ms