explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SHp4

Settings
# exclusive inclusive rows x rows loops node
1. 19.802 512.749 ↓ 0.0 0 1

Hash Left Join (cost=32,536.17..398,137.05 rows=3,542 width=8) (actual time=512.749..512.749 rows=0 loops=1)

  • Hash Cond: (aea.ev_id = evs.ev_id)
  • Filter: (((aea.ev_id IS NOT NULL) AND (evs.ev_id IS NULL)) OR (aea.ev_id IS NULL))
  • Rows Removed by Filter: 62886
2. 68.398 76.417 ↑ 5.3 62,886 1

Bitmap Heap Scan on audit_evs_all aea (cost=3,878.77..368,610.80 rows=330,988 width=16) (actual time=8.547..76.417 rows=62,886 loops=1)

  • Recheck Cond: (((when_created <= '2019-06-12 09:53:28.924+00'::timestamp with time zone) AND (ev_id IS NOT NULL)) OR ((when_created <= '2019-06-12 09:53:28.924+00'::timestamp with time zone) AND (ev_id IS NULL)))
  • Heap Blocks: exact=3672
3. 0.004 8.019 ↓ 0.0 0 1

BitmapOr (cost=3,878.77..3,878.77 rows=330,988 width=0) (actual time=8.019..8.019 rows=0 loops=1)

4. 7.978 7.978 ↑ 5.2 62,886 1

Bitmap Index Scan on idx_audit_evs_all_when_created (cost=0.00..3,672.79 rows=327,447 width=0) (actual time=7.978..7.978 rows=62,886 loops=1)

  • Index Cond: (when_created <= '2019-06-12 09:53:28.924+00'::timestamp with time zone)
5. 0.037 0.037 ↓ 0.0 0 1

Bitmap Index Scan on idx_audit_evs_all_when_created_null (cost=0.00..40.49 rows=3,542 width=0) (actual time=0.037..0.037 rows=0 loops=1)

  • Index Cond: (when_created <= '2019-06-12 09:53:28.924+00'::timestamp with time zone)
6. 178.133 416.530 ↑ 1.1 589,691 1

Hash (cost=20,626.48..20,626.48 rows=642,473 width=8) (actual time=416.530..416.530 rows=589,691 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 31227kB
7. 238.397 238.397 ↑ 1.1 589,691 1

Index Only Scan using evs_pk on evs (cost=0.42..20,626.48 rows=642,473 width=8) (actual time=0.125..238.397 rows=589,691 loops=1)

  • Heap Fetches: 104454
Planning time : 18.383 ms
Execution time : 514.878 ms