explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OHfH

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,669.224 ↓ 1.7 492 1

Gather Merge (cost=26,189.95..26,222.38 rows=282 width=68) (actual time=2,656.352..2,669.224 rows=492 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=9185 read=5413
2. 2.504 5,298.316 ↑ 1.1 246 2

Sort (cost=25,189.94..25,190.65 rows=282 width=68) (actual time=2,649.093..2,649.158 rows=246 loops=2)

  • Sort Key: t.created_at DESC
  • Sort Method: quicksort Memory: 54kB
  • Worker 0: Sort Method: quicksort Memory: 64kB
  • Buffers: shared hit=9185 read=5413
3. 12.186 5,295.812 ↑ 1.1 246 2

Nested Loop (cost=67.15..25,178.47 rows=282 width=68) (actual time=183.201..2,647.906 rows=246 loops=2)

  • Buffers: shared hit=9178 read=5413
4. 31.298 33.570 ↑ 1.2 1,446 2

Parallel Bitmap Heap Scan on people_nondist p (cost=66.71..5,991.51 rows=1,692 width=36) (actual time=1.771..16.785 rows=1,446 loops=2)

  • Recheck Cond: (city_of_birth = 'Veszprém'::text)
  • Heap Blocks: exact=1133
  • Buffers: shared hit=2504
5. 2.272 2.272 ↓ 1.0 2,891 1

Bitmap Index Scan on people_nondist_cob_idx (cost=0.00..65.99 rows=2,876 width=0) (actual time=2.271..2.272 rows=2,891 loops=1)

  • Index Cond: (city_of_birth = 'Veszprém'::text)
  • Buffers: shared hit=14
6. 11.564 5,250.056 ↓ 0.0 0 2,891

Append (cost=0.44..11.33 rows=1 width=32) (actual time=1.807..1.816 rows=0 loops=2,891)

  • Buffers: shared hit=6674 read=5413
7. 5,238.492 5,238.492 ↓ 0.0 0 2,891

Index Scan using transactions_pt_07_10_people_id_idx on transactions_pt_07_10 t (cost=0.44..11.32 rows=1 width=32) (actual time=1.803..1.812 rows=0 loops=2,891)

  • Index Cond: (people_id = p.id)
  • Filter: ((created_at >= '2019-01-09 12:00:00'::timestamp without time zone) AND (created_at < '2019-01-09 20:00:00'::timestamp without time zone) AND (amount > 8000))
  • Rows Removed by Filter: 20
  • Buffers: shared hit=6674 read=5413