explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k4sm

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

Limit (cost=10.58..1,582.72 rows=5 width=8) (actual time=0.043..0.043 rows=0 loops=1)

2. 0.000 0.042 ↓ 0.0 0 1

Nested Loop Left Join (cost=10.58..1,582.72 rows=5 width=8) (actual time=0.042..0.042 rows=0 loops=1)

  • Filter: (((aea.ev_id IS NOT NULL) AND (evs.ev_id IS NULL)) OR (aea.ev_id IS NULL))
3. 0.002 0.042 ↓ 0.0 0 1

Bitmap Heap Scan on audit_evs_all aea (cost=10.16..697.93 rows=457 width=16) (actual time=0.042..0.042 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 ((when_created >= '2019-06-01 00:00:00+00'::timestamp with time zone) AND
4. 0.001 0.040 ↓ 0.0 0 1

BitmapOr (cost=10.16..10.16 rows=457 width=0) (actual time=0.040..0.040 rows=0 loops=1)

5. 0.020 0.020 ↓ 0.0 0 1

Bitmap Index Scan on idx_audit_evs_all_when_created (cost=0.00..7.96 rows=452 width=0) (actual time=0.020..0.020 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. 0.019 0.019 ↓ 0.0 0 1

Bitmap Index Scan on idx_audit_evs_all_when_created_null (cost=0.00..1.97 rows=5 width=0) (actual time=0.019..0.019 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))
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 : 16.885 ms
Execution time : 0.132 ms