explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DYcI

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 52.413 ↓ 2.0 40 1

Gather Merge (cost=17,055.32..17,057.62 rows=20 width=68) (actual time=43.455..52.413 rows=40 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=10029 read=1840
2. 0.232 71.940 ↑ 1.0 20 2

Sort (cost=16,055.31..16,055.36 rows=20 width=68) (actual time=35.965..35.970 rows=20 loops=2)

  • Sort Key: t.created_at DESC
  • Sort Method: quicksort Memory: 29kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=10029 read=1840
3. 2.615 71.708 ↑ 1.0 20 2

Nested Loop (cost=67.14..16,054.88 rows=20 width=68) (actual time=6.443..35.854 rows=20 loops=2)

  • Buffers: shared hit=10022 read=1840
4. 15.374 17.430 ↑ 1.1 1,520 2

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

  • Recheck Cond: (city_of_birth = 'Balatonfüred'::text)
  • Heap Blocks: exact=1887
  • Buffers: shared hit=2564
5. 2.056 2.056 ↓ 1.1 3,039 1

Bitmap Index Scan on people_nondist_cob_idx (cost=0.00..65.99 rows=2,876 width=0) (actual time=2.056..2.056 rows=3,039 loops=1)

  • Index Cond: (city_of_birth = 'Balatonfüred'::text)
  • Buffers: shared hit=15
6. 3.039 51.663 ↓ 0.0 0 3,039

Append (cost=0.42..5.94 rows=1 width=32) (actual time=0.017..0.017 rows=0 loops=3,039)

  • Buffers: shared hit=7458 read=1840
7. 48.624 48.624 ↓ 0.0 0 3,039

Index Scan using transactions_pt_11_13_people_id_created_at_idx on transactions_pt_11_13 t (cost=0.42..5.93 rows=1 width=32) (actual time=0.016..0.016 rows=0 loops=3,039)

  • Index Cond: ((people_id = p.id) AND (created_at >= '2019-01-13 12:00:00'::timestamp without time zone) AND (created_at < '2019-01-13 19:00:00'::timestamp without time zone))
  • Filter: (amount > 6000)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=7458 read=1840