explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dHIy

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

Delete on audit_evs_all aea (cost=2,293,620.98..4,153,870.42 rows=1,428,092 width=38) (actual rows=0 loops=1)

  • Buffers: shared hit=26,623,857 read=1,697,662 dirtied=405,651 written=31,809
  • I/O Timings: read=1,786,217.712 write=1,518.792
2. 0.000 0.000 ↑ 1.7 845,802 1

Hash Join (cost=2,293,620.98..4,153,870.42 rows=1,428,092 width=38) (actual rows=845,802 loops=1)

  • Hash Cond: (aea.audit_ev_id = aea2.audit_ev_id)
  • Buffers: shared hit=264,806 read=1,428,918 dirtied=5,153 written=31,809
  • I/O Timings: read=71,340.910 write=1,518.792
3. 0.000 0.000 ↓ 1.0 31,270,663 1

Seq Scan on audit_evs_all aea (cost=0.00..1,779,047.96 rows=30,933,896 width=14) (actual rows=31,270,663 loops=1)

  • Buffers: shared hit=45,705 read=1,424,004 dirtied=5,034 written=31,809
  • I/O Timings: read=71,257.789 write=1,518.792
4. 0.000 0.000 ↑ 1.7 845,802 1

Hash (cost=2,275,769.83..2,275,769.83 rows=1,428,092 width=40) (actual rows=845,802 loops=1)

  • Buckets: 2,097,152 Batches: 1 Memory Usage: 75,855kB
  • Buffers: shared hit=219,101 read=4,914 dirtied=119
  • I/O Timings: read=83.121
5. 0.000 0.000 ↑ 1.7 845,802 1

Subquery Scan on aea2 (cost=16,763.78..2,275,769.83 rows=1,428,092 width=40) (actual rows=845,802 loops=1)

  • Buffers: shared hit=219,101 read=4,914 dirtied=119
  • I/O Timings: read=83.121
6. 0.000 0.000 ↑ 1.7 845,802 1

HashSetOp Except (cost=16,763.78..2,261,488.91 rows=1,428,092 width=12) (actual rows=845,802 loops=1)

  • Buffers: shared hit=219,101 read=4,914 dirtied=119
  • I/O Timings: read=83.121
7. 0.000 0.000 ↑ 3.4 845,802 1

Append (cost=16,763.78..2,254,385.10 rows=2,841,522 width=12) (actual rows=845,802 loops=1)

  • Buffers: shared hit=219,101 read=4,914 dirtied=119
  • I/O Timings: read=83.121
8. 0.000 0.000 ↑ 1.7 845,802 1

Subquery Scan on *SELECT* 1 (cost=16,763.78..1,101,972.29 rows=1,428,092 width=12) (actual rows=845,802 loops=1)

  • Buffers: shared hit=71,052
9. 0.000 0.000 ↑ 1.7 845,802 1

Bitmap Heap Scan on audit_evs_all aea_1 (cost=16,763.78..1,087,691.37 rows=1,428,092 width=8) (actual rows=845,802 loops=1)

  • Recheck Cond: (when_created <= '2020-08-26 01:15:21.616+00'::timestamp with time zone)
  • Heap Blocks: exact=48,600
  • Buffers: shared hit=71,052
10. 0.000 0.000 ↓ 1.0 1,430,670 1

Bitmap Index Scan on idx_audit_evs_all_when_created (cost=0.00..16,406.75 rows=1,428,092 width=0) (actual rows=1,430,670 loops=1)

  • Index Cond: (when_created <= '2020-08-26 01:15:21.616+00'::timestamp with time zone)
  • Buffers: shared hit=6,165
11. 0.000 0.000 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=49,394.54..1,138,205.20 rows=1,413,430 width=12) (actual rows=0 loops=1)

  • Buffers: shared hit=148,049 read=4,914 dirtied=119
  • I/O Timings: read=83.121
12. 0.000 0.000 ↓ 0.0 0 1

Hash Join (cost=49,394.54..1,124,070.90 rows=1,413,430 width=8) (actual rows=0 loops=1)

  • Hash Cond: (aea_2.ev_id = evs.ev_id)
  • Buffers: shared hit=148,049 read=4,914 dirtied=119
  • I/O Timings: read=83.121
13. 0.000 0.000 ↑ 1.7 845,802 1

Bitmap Heap Scan on audit_evs_all aea_2 (cost=16,763.78..1,087,691.37 rows=1,428,092 width=16) (actual rows=845,802 loops=1)

  • Recheck Cond: (when_created <= '2020-08-26 01:15:21.616+00'::timestamp with time zone)
  • Heap Blocks: exact=48,600
  • Buffers: shared hit=71,052
14. 0.000 0.000 ↓ 1.0 1,430,670 1

Bitmap Index Scan on idx_audit_evs_all_when_created (cost=0.00..16,406.75 rows=1,428,092 width=0) (actual rows=1,430,670 loops=1)

  • Index Cond: (when_created <= '2020-08-26 01:15:21.616+00'::timestamp with time zone)
  • Buffers: shared hit=6,165
15. 0.000 0.000 ↑ 1.0 583,073 1

Hash (cost=25,270.77..25,270.77 rows=588,800 width=8) (actual rows=583,073 loops=1)

  • Buckets: 1,048,576 Batches: 1 Memory Usage: 30,969kB
  • Buffers: shared hit=76,997 read=4,914 dirtied=119
  • I/O Timings: read=83.121
16. 0.000 0.000 ↑ 1.0 583,073 1

Index Only Scan using evs_pk on evs (cost=0.42..25,270.77 rows=588,800 width=8) (actual rows=583,073 loops=1)

  • Heap Fetches: 145,430
  • Buffers: shared hit=76,997 read=4,914 dirtied=119
  • I/O Timings: read=83.121