explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XnrR

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.069 ↑ 1.0 1 1

Limit (cost=382.88..382.89 rows=1 width=19) (actual time=0.069..0.069 rows=1 loops=1)

2. 0.010 0.067 ↑ 1.0 1 1

Sort (cost=382.88..382.89 rows=1 width=19) (actual time=0.067..0.067 rows=1 loops=1)

  • Sort Key: creation_date DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.057 0.057 ↑ 1.0 1 1

Index Scan using idx_audit_evs_all_niaaet on audit_evs_all a (cost=0.57..382.87 rows=1 width=19) (actual time=0.044..0.057 rows=1 loops=1)

  • Index Cond: (ntfn_id = 317617624)
  • Filter: ((response IS NOT NULL) AND (ev_id = 78572093) AND ((ntfn_cat)::text = 'PERSON'::text))
  • Rows Removed by Filter: 9
Planning time : 0.453 ms
Execution time : 0.123 ms