explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ungZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.474 2,496.149 ↓ 34.0 885 1

Nested Loop (cost=312,428.89..382,455.22 rows=26 width=33) (actual time=2,458.987..2,496.149 rows=885 loops=1)

2. 0.610 2,494.790 ↓ 30.5 885 1

Nested Loop (cost=312,428.62..382,446.59 rows=29 width=49) (actual time=2,458.951..2,494.790 rows=885 loops=1)

3. 0.150 2,458.405 ↓ 1.0 265 1

Finalize GroupAggregate (cost=312,428.05..312,434.65 rows=264 width=20) (actual time=2,458.169..2,458.405 rows=265 loops=1)

  • Group Key: x18.home_id
4. 0.377 2,458.255 ↓ 1.5 795 1

Sort (cost=312,428.05..312,429.37 rows=528 width=20) (actual time=2,458.164..2,458.255 rows=795 loops=1)

  • Sort Key: x18.home_id
  • Sort Method: quicksort Memory: 87kB
5. 4.949 2,457.878 ↓ 1.5 795 1

Gather (cost=312,348.74..312,404.18 rows=528 width=20) (actual time=2,456.696..2,457.878 rows=795 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 1,391.054 2,452.929 ↓ 1.0 265 3 / 3

Partial HashAggregate (cost=311,348.74..311,351.38 rows=264 width=20) (actual time=2,452.879..2,452.929 rows=265 loops=3)

  • Group Key: x18.home_id
7. 1,061.875 1,061.875 ↑ 1.4 6,568,110 3 / 3

Parallel Seq Scan on home_dated_prices x18 (cost=0.00..266,870.49 rows=8,895,649 width=20) (actual time=0.005..1,061.875 rows=6,568,110 loops=3)

8. 35.775 35.775 ↓ 3.0 3 265

Index Scan using pk_home_dated_prices on home_dated_prices home_dated_price (cost=0.56..265.18 rows=1 width=33) (actual time=0.021..0.135 rows=3 loops=265)

  • Index Cond: ((home_id = x18.home_id) AND (home_id = ANY ('{24cd0d6b-e787-11e9-91dd-f9c1bf98ce9f,1207cfcc-c9eb-11e9-884b-0bce066fc6a6,204ea7e7-4f59-11e9-87e3-c7b51e870a93,e74d8b3e-ca6f-11e9-884b-092f4327cc74,515c5574-4f59-11e9-87e3-010017020cdd,0eb64e2b-c8f2-11e9-b363-d7fc46e7861b,16d3706b-4f59-11e9-87e3-dbe012200ecf,462c6680-dc06-11e9-84f4-a76110157852,346eaecf-ec6d-11e9-957f-8b3941ee0350,0b53418a-4f59-11e9-87e3-95f103698579,0568845c-4f59-11e9-87e3-5dfeb911e980,849c250a-4f59-11e9-87e3-1f2ac6cd5955,c4bbc893-c2b9-11e9-bdd2-2db4f3b95b21,da124784-cad0-11e9-884b-8b0ce88f33cc,1894cfa6-4f59-11e9-87e3-d3a6140a91bb}'::uuid[])) AND (created_at = (max(x18.created_at))))
  • Filter: (date <@ '[2020-01-31,2020-03-30)'::daterange)
  • Rows Removed by Filter: 36
9. 0.885 0.885 ↑ 1.0 1 885

Index Only Scan using pk_home_details on home_details x17 (cost=0.27..0.30 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=885)

  • Index Cond: (home_id = home_dated_price.home_id)
  • Heap Fetches: 885
Planning time : 1.035 ms
Execution time : 2,496.332 ms