explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FctM

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.815 ↑ 1.0 1 1

Limit (cost=0.56..206.75 rows=1 width=59) (actual time=0.814..0.815 rows=1 loops=1)

2. 0.812 0.812 ↑ 10,217.0 1 1

Index Scan using driver_events_raw_index02 on driver_events_raw de (cost=0.56..2,106,546.22 rows=10,217 width=59) (actual time=0.812..0.812 rows=1 loops=1)

  • Filter: ((status_id > 0) AND ((driver)::text = 'UAD00000700820'::text))
  • Rows Removed by Filter: 404