explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lov2

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 431.305 ↑ 1.0 5 1

Limit (cost=147,532.61..147,533.19 rows=5 width=20) (actual time=382.181..431.305 rows=5 loops=1)

  • Output: p0_.id, p0_.partition_id, p2_.translatable_id, p0_.added_at
  • Buffers: shared hit=666,344
2. 53.749 431.300 ↑ 11,837.2 5 1

Gather Merge (cost=147,532.61..154,438.12 rows=59,186 width=20) (actual time=382.180..431.300 rows=5 loops=1)

  • Output: p0_.id, p0_.partition_id, p2_.translatable_id, p0_.added_at
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=666,344
3. 9.317 377.551 ↑ 7,398.2 4 3 / 3

Sort (cost=146,532.58..146,606.56 rows=29,593 width=20) (actual time=377.551..377.551 rows=4 loops=3)

  • Output: p0_.id, p0_.partition_id, p2_.translatable_id, p0_.added_at
  • Sort Key: p0_.added_at DESC
  • Sort Method: top-N heapsort Memory: 25kB
  • Worker 0: Sort Method: top-N heapsort Memory: 25kB
  • Worker 1: Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=666,344
  • Worker 0: actual time=374.970..374.970 rows=5 loops=1
  • Buffers: shared hit=195,808
  • Worker 1: actual time=376.114..376.114 rows=5 loops=1
  • Buffers: shared hit=230,079
4. 0.000 368.234 ↓ 1.6 46,050 3 / 3

Nested Loop Left Join (cost=1,083.53..146,041.05 rows=29,593 width=20) (actual time=16.620..368.234 rows=46,050 loops=3)

  • Output: p0_.id, p0_.partition_id, p2_.translatable_id, p0_.added_at
  • Inner Unique: true
  • Buffers: shared hit=666,328
  • Worker 0: actual time=14.683..366.994 rows=38,811 loops=1
  • Buffers: shared hit=195,800
  • Worker 1: actual time=35.141..366.174 rows=50,175 loops=1
  • Buffers: shared hit=230,071
5. 4.366 186.384 ↓ 1.6 46,050 3 / 3

Parallel Append (cost=1,083.10..81,190.81 rows=29,179 width=20) (actual time=16.578..186.384 rows=46,050 loops=3)

  • Buffers: shared hit=113,331
  • Worker 0: actual time=14.630..195.941 rows=38,811 loops=1
  • Buffers: shared hit=40,430
  • Worker 1: actual time=35.086..153.145 rows=50,175 loops=1
  • Buffers: shared hit=29,233
6. 64.887 73.694 ↓ 2.9 24,418 3 / 3

Parallel Bitmap Heap Scan on public.property_flat p0_ (cost=2,138.32..25,959.37 rows=8,402 width=20) (actual time=11.852..73.694 rows=24,418 loops=3)

  • Output: p0_.id, p0_.partition_id, p0_.added_at, p0_.contact_id
  • Recheck Cond: ((p0_.country_code = 'pl'::bpchar) AND (p0_.owner_information_type = '1'::smallint))
  • Filter: ((p0_.added_at >= '2019-07-27 22:00:00+00'::timestamp with time zone) AND (p0_.active_frontends @> '{5}'::integer[]))
  • Rows Removed by Filter: 11,241
  • Heap Blocks: exact=10,871
  • Buffers: shared hit=49,507
  • Worker 0: actual time=0.115..36.690 rows=10,719 loops=1
  • Buffers: shared hit=9,403
  • Worker 1: actual time=35.085..148.440 rows=50,175 loops=1
  • Buffers: shared hit=29,233
7. 0.796 8.807 ↓ 0.0 0 1 / 3

BitmapAnd (cost=2,138.32..2,138.32 rows=25,049 width=0) (actual time=26.420..26.420 rows=0 loops=1)

  • Buffers: shared hit=667
  • Worker 1: actual time=26.420..26.420 rows=0 loops=1
  • Buffers: shared hit=667
8. 4.791 4.791 ↓ 1.0 126,627 1 / 3

Bitmap Index Scan on property_flat_country_code_idx (cost=0.00..1,010.35 rows=124,107 width=0) (actual time=14.373..14.373 rows=126,627 loops=1)

  • Buffers: shared hit=360
  • Worker 1: actual time=14.373..14.373 rows=126,627 loops=1
  • Buffers: shared hit=360
9. 3.220 3.220 ↓ 1.0 108,087 1 / 3

Bitmap Index Scan on property_flat_owner_information_type_idx (cost=0.00..1,117.63 rows=105,841 width=0) (actual time=9.659..9.659 rows=108,087 loops=1)

  • Index Cond: (p0_.owner_information_type = '1'::smallint)
  • Buffers: shared hit=307
  • Worker 1: actual time=9.659..9.659 rows=108,087 loops=1
  • Buffers: shared hit=307
10. 32.211 35.921 ↓ 6.7 23,057 1 / 3

Parallel Bitmap Heap Scan on public.property_house p0__1 (cost=1,083.10..12,796.73 rows=3,425 width=20) (actual time=14.629..107.763 rows=23,057 loops=1)

  • Output: p0__1.id, p0__1.partition_id, p0__1.added_at, p0__1.contact_id
  • Recheck Cond: ((p0__1.country_code = 'pl'::bpchar) AND (p0__1.owner_information_type = '1'::smallint))
  • Filter: ((p0__1.added_at >= '2019-07-27 22:00:00+00'::timestamp with time zone) AND (p0__1.active_frontends @> '{5}'::integer[]))
  • Rows Removed by Filter: 33,270
  • Buffers: shared hit=23,335
  • Worker 0: actual time=14.629..107.763 rows=23,057 loops=1
  • Buffers: shared hit=23,335
11. 0.259 3.710 ↓ 0.0 0 1 / 3

BitmapAnd (cost=1,083.10..1,083.10 rows=12,172 width=0) (actual time=11.131..11.131 rows=0 loops=1)

  • Buffers: shared hit=330
  • Worker 0: actual time=11.131..11.131 rows=0 loops=1
  • Buffers: shared hit=330
12. 1.864 1.864 ↑ 1.0 58,272 1 / 3

Bitmap Index Scan on property_house_country_code_idx (cost=0.00..474.24 rows=58,358 width=0) (actual time=5.592..5.592 rows=58,272 loops=1)

  • Buffers: shared hit=166
  • Worker 0: actual time=5.592..5.592 rows=58,272 loops=1
  • Buffers: shared hit=166
13. 1.587 1.587 ↑ 1.0 57,048 1 / 3

Bitmap Index Scan on property_house_owner_information_type_idx (cost=0.00..604.50 rows=57,224 width=0) (actual time=4.761..4.761 rows=57,048 loops=1)

  • Index Cond: (p0__1.owner_information_type = '1'::smallint)
  • Buffers: shared hit=164
  • Worker 0: actual time=4.761..4.761 rows=57,048 loops=1
  • Buffers: shared hit=164
14. 72.403 72.403 ↓ 1.2 20,918 2 / 3

Parallel Seq Scan on public.property_other p0__2 (cost=0.00..42,288.81 rows=17,352 width=20) (actual time=0.016..108.605 rows=20,918 loops=2)

  • Output: p0__2.id, p0__2.partition_id, p0__2.added_at, p0__2.contact_id
  • Filter: ((p0__2.added_at >= '2019-07-27 22:00:00+00'::timestamp with time zone) AND (p0__2.active_frontends @> '{5}'::integer[]) AND (p0__2.country_code = 'pl'::bpchar) AND (p0__2.owner_information_type = '1'::smallint))
  • Rows Removed by Filter: 87,070
  • Buffers: shared hit=40,489
  • Worker 0: actual time=0.015..47.655 rows=5,035 loops=1
  • Buffers: shared hit=7,692
15. 184.199 184.199 ↑ 1.0 1 138,149 / 3

Index Only Scan using property_translation_unique_translation on public.property_translation p2_ (cost=0.43..2.22 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=138,149)

  • Output: p2_.translatable_id, p2_.locale
  • Index Cond: ((p2_.translatable_id = p0_.id) AND (p2_.locale = 'pl'::text))
  • Heap Fetches: 138,149
  • Buffers: shared hit=552,997
  • Worker 0: actual time=0.004..0.004 rows=1 loops=38,811
  • Buffers: shared hit=155,370
  • Worker 1: actual time=0.004..0.004 rows=1 loops=50,175
  • Buffers: shared hit=200,838
Planning time : 1.245 ms
Execution time : 431.373 ms