explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EUlD

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 19,585.598 ↓ 0.0 0 1

Limit (cost=4,489.02..376,690.88 rows=5 width=8) (actual time=19,585.598..19,585.598 rows=0 loops=1)

2. 0.002 19,585.595 ↓ 0.0 0 1

Nested Loop Left Join (cost=4,489.02..376,690.88 rows=5 width=8) (actual time=19,585.595..19,585.595 rows=0 loops=1)

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

Bitmap Heap Scan on audit_evs_all aea (cost=4,488.59..375,808.04 rows=456 width=16) (actual time=19,585.593..19,585.593 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: 323325
  • Heap Blocks: exact=256067
4. 0.006 125.237 ↓ 0.0 0 1

BitmapOr (cost=4,488.59..4,488.59 rows=337,766 width=0) (actual time=125.237..125.237 rows=0 loops=1)

5. 0.082 0.082 ↓ 0.0 0 1

Bitmap Index Scan on idx_audit_evs_all_when_created (cost=0.00..7.95 rows=451 width=0) (actual time=0.082..0.082 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. 125.149 125.149 ↑ 1.0 323,325 1

Bitmap Index Scan on idx_audit_evs_all_ei (cost=0.00..4,480.42 rows=337,314 width=0) (actual time=125.149..125.149 rows=323,325 loops=1)

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

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

  • Index Cond: (ev_id = aea.ev_id)
  • Heap Fetches: 0
Planning time : 17.084 ms
Execution time : 19,590.332 ms