explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4DaF

Settings
# exclusive inclusive rows x rows loops node
1. 41.577 783.007 ↑ 3.4 4,270 1

Gather (cost=46,573.15..1,000,012.74 rows=14,362 width=8) (actual time=457.156..783.007 rows=4,270 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 85.928 741.430 ↑ 4.2 854 5

Hash Anti Join (cost=45,573.15..997,576.54 rows=3,590 width=8) (actual time=596.405..741.430 rows=854 loops=5)

  • Hash Cond: (aea.ev_id = evs.ev_id)
3. 164.953 274.387 ↑ 1.3 278,821 5

Parallel Bitmap Heap Scan on audit_evs_all aea (cost=16,915.75..967,503.92 rows=368,897 width=16) (actual time=115.937..274.387 rows=278,821 loops=5)

  • Recheck Cond: ((when_created <= '2019-06-15 09:53:28.924+00'::timestamp with time zone) AND (ev_id IS NOT NULL))
  • Heap Blocks: exact=18250
4. 109.434 109.434 ↑ 1.1 1,394,104 1

Bitmap Index Scan on idx_audit_evs_all_when_created (cost=0.00..16,546.85 rows=1,475,589 width=0) (actual time=109.434..109.434 rows=1,394,104 loops=1)

  • Index Cond: (when_created <= '2019-06-15 09:53:28.924+00'::timestamp with time zone)
5. 177.736 381.115 ↑ 1.1 590,256 5

Hash (cost=20,626.48..20,626.48 rows=642,473 width=8) (actual time=381.115..381.115 rows=590,256 loops=5)

  • Buckets: 1048576 Batches: 1 Memory Usage: 31249kB
6. 203.379 203.379 ↑ 1.1 590,256 5

Index Only Scan using evs_pk on evs (cost=0.42..20,626.48 rows=642,473 width=8) (actual time=0.122..203.379 rows=590,256 loops=5)

  • Heap Fetches: 108706
Planning time : 1.079 ms
Execution time : 786.909 ms