explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qi9

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

Delete on analytics_filter_events e1 (cost=56,376.48..82,055.55 rows=253,960 width=12) (actual time=663.017..663.017 rows=0 loops=1)

2. 157.459 663.014 ↓ 0.0 0 1

Hash Semi Join (cost=56,376.48..82,055.55 rows=253,960 width=12) (actual time=663.014..663.014 rows=0 loops=1)

  • Hash Cond: (e1.event_id = e2.event_id)
3. 53.017 66.195 ↓ 1.0 287,695 1

Bitmap Heap Scan on analytics_filter_events e1 (cost=6,205.45..19,486.28 rows=286,067 width=14) (actual time=13.453..66.195 rows=287,695 loops=1)

  • Recheck Cond: (filter_id = 1)
  • Heap Blocks: exact=2264
4. 13.178 13.178 ↓ 1.0 287,931 1

Bitmap Index Scan on analytics_filter_events_filter_id (cost=0.00..6,133.93 rows=286,067 width=0) (actual time=13.178..13.178 rows=287,931 loops=1)

  • Index Cond: (filter_id = 1)
5. 215.715 439.360 ↑ 1.0 1,232,968 1

Hash (cost=28,711.94..28,711.94 rows=1,234,488 width=14) (actual time=439.360..439.360 rows=1,232,968 loops=1)

  • Buckets: 131072 Batches: 32 Memory Usage: 2823kB
6. 223.645 223.645 ↑ 1.0 1,232,968 1

Seq Scan on analytics_filter_events e2 (cost=0.00..28,711.94 rows=1,234,488 width=14) (actual time=0.015..223.645 rows=1,232,968 loops=1)

  • Filter: (filter_id <> 1)
  • Rows Removed by Filter: 287695