explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n8PB

Settings
# exclusive inclusive rows x rows loops node
1. 8.068 3,712.455 ↑ 1.0 100,000 1

Limit (cost=29,657.39..515,804.87 rows=100,000 width=8) (actual time=1,797.291..3,712.455 rows=100,000 loops=1)

2. 56.408 3,704.387 ↑ 2.7 100,000 1

Gather (cost=29,657.39..1,327,977.43 rows=267,063 width=8) (actual time=1,797.289..3,704.387 rows=100,000 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 442.416 3,647.979 ↑ 3.3 20,001 5

Hash Left Join (cost=28,657.39..1,300,271.13 rows=66,766 width=8) (actual time=1,789.957..3,647.979 rows=20,001 loops=5)

  • 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: 1873084
4. 1,421.677 1,421.677 ↑ 3.3 1,893,085 5

Parallel Seq Scan on audit_evs_all aea (cost=0.00..1,255,234.19 rows=6,239,785 width=16) (actual time=0.075..1,421.677 rows=1,893,085 loops=5)

  • Filter: ((when_created >= '2019-06-01 00:00:00+00'::timestamp with time zone) AND (when_created <= '2019-07-02 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 734825
5. 207.821 1,783.886 ↑ 1.1 589,492 5

Hash (cost=20,626.48..20,626.48 rows=642,473 width=8) (actual time=1,783.886..1,783.886 rows=589,492 loops=5)

  • Buckets: 1048576 Batches: 1 Memory Usage: 31220kB
6. 1,576.065 1,576.065 ↑ 1.1 589,492 5

Index Only Scan using evs_pk on evs (cost=0.42..20,626.48 rows=642,473 width=8) (actual time=0.130..1,576.065 rows=589,492 loops=5)

  • Heap Fetches: 115010
Planning time : 12.620 ms
Execution time : 3,717.255 ms