explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cqai

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1,800.172 ↓ 0.0 0 1

Limit (cost=5,592.24..427,905.69 rows=5 width=8) (actual time=1,800.172..1,800.172 rows=0 loops=1)

2. 0.002 1,800.171 ↓ 0.0 0 1

Nested Loop Left Join (cost=5,592.24..427,905.69 rows=5 width=8) (actual time=1,800.171..1,800.171 rows=0 loops=1)

  • Filter: (((aea.ev_id IS NOT NULL) AND (evs.ev_id IS NULL)) OR (aea.ev_id IS NULL))
3. 1,677.715 1,800.169 ↓ 0.0 0 1

Bitmap Heap Scan on audit_evs_all aea (cost=5,591.82..426,969.68 rows=484 width=16) (actual time=1,800.169..1,800.169 rows=0 loops=1)

  • Recheck Cond: (((when_created >= '2019-06-01 00:00:00+00'::timestamp with time zone) AND (when_created <= '2019-06-02 00:00:00+00'::timestamp with time zone) AND (ev_id IS NOT NULL)) OR (ev_id IS NULL))
  • Filter: ((when_created >= '2019-06-01 00:00:00+00'::timestamp with time zone) AND (when_created <= '2019-06-02 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 322926
  • Heap Blocks: exact=238304
4. 0.002 122.454 ↓ 0.0 0 1

BitmapOr (cost=5,591.82..5,591.82 rows=374,434 width=0) (actual time=122.454..122.454 rows=0 loops=1)

5. 0.070 0.070 ↓ 0.0 0 1

Bitmap Index Scan on idx_audit_evs_all_when_created (cost=0.00..8.34 rows=478 width=0) (actual time=0.070..0.070 rows=0 loops=1)

  • Index Cond: ((when_created >= '2019-06-01 00:00:00+00'::timestamp with time zone) AND (when_created <= '2019-06-02 00:00:00+00'::timestamp with time zone))
6. 122.382 122.382 ↑ 1.1 325,474 1

Bitmap Index Scan on idx_audit_evs_all_ei (cost=0.00..5,583.23 rows=373,956 width=0) (actual time=122.382..122.382 rows=325,474 loops=1)

  • Index Cond: (ev_id IS NULL)
7. 0.000 0.000 ↓ 0.0 0

Index Only Scan using evs_pk on evs (cost=0.42..1.92 rows=1 width=8) (never executed)

  • Index Cond: (ev_id = aea.ev_id)
  • Heap Fetches: 0
Planning time : 16.091 ms
Execution time : 1,805.750 ms