explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aBz

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 287.766 ↑ 1.0 100 1

Limit (cost=1,004.33..3,710.53 rows=100 width=5,704) (actual time=18.080..287.766 rows=100 loops=1)

2. 0.000 287.746 ↑ 3,493.4 100 1

Gather Merge (cost=1,004.33..9,454,766.82 rows=349,337 width=5,704) (actual time=18.079..287.746 rows=100 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
3. 0.265 1,521.898 ↑ 1,819.5 32 7

Nested Loop Left Join (cost=4.23..9,410,436.08 rows=58,223 width=5,711) (actual time=5.746..217.414 rows=32 loops=7)

4. 0.314 1,521.408 ↑ 1,819.5 32 7

Nested Loop Left Join (cost=4.08..9,260,802.57 rows=58,223 width=5,702) (actual time=5.739..217.344 rows=32 loops=7)

5. 0.354 1,520.869 ↑ 1,819.5 32 7

Nested Loop Left Join (cost=3.93..8,989,482.96 rows=58,223 width=5,591) (actual time=5.732..217.267 rows=32 loops=7)

6. 0.412 1,519.840 ↑ 1,819.5 32 7

Nested Loop Left Join (cost=3.51..8,670,231.73 rows=58,223 width=4,326) (actual time=5.720..217.120 rows=32 loops=7)

7. 0.607 1,514.478 ↑ 1,819.5 32 7

Nested Loop Left Join (cost=2.96..8,343,659.49 rows=58,223 width=3,656) (actual time=5.699..216.354 rows=32 loops=7)

8. 0.839 1,351.196 ↑ 1,819.5 32 7

Nested Loop Left Join (cost=2.40..8,012,290.76 rows=58,223 width=3,111) (actual time=4.892..193.028 rows=32 loops=7)

9. 0.555 1,093.407 ↑ 1,819.5 32 7

Nested Loop (cost=1.83..7,679,315.38 rows=58,223 width=2,036) (actual time=4.255..156.201 rows=32 loops=7)

10. 0.655 853.902 ↑ 1,819.5 32 7

Nested Loop (cost=1.27..7,260,360.27 rows=58,223 width=598) (actual time=2.921..121.986 rows=32 loops=7)

11. 38.339 38.339 ↑ 2,287.8 101 7

Parallel Index Scan using transactioninfo_primary_external_listing_sha_idx on transactioninfo (cost=0.70..5,531,783.25 rows=231,067 width=565) (actual time=1.023..5.477 rows=101 loops=7)

  • Index Cond: ((primary_external_listing_sha > '1c732024351db892c0ecb0779cb5a6731b50039c'::bpchar) AND (primary_external_listing_sha < '1ed097b4'::bpchar))
12. 814.908 814.908 ↓ 0.0 0 708

Index Scan using listing_pkey on listing (cost=0.57..7.48 rows=1 width=49) (actual time=1.151..1.151 rows=0 loops=708)

  • Index Cond: (messier_listing_id = transactioninfo.primary_listing)
  • Filter: ((source_feed)::text = ANY ('{san_antonio_sabor,greenwich_ct_newcanaan,santa_barbara_montecito_rentals,aspen_mls_rets,orlando_smyrnamls_trestle,olr_vow_sales,national_newhome,richmond_va_cvrmls,gmls_rets,atlanta_fmls,bakersfield_avmls,philadelphia_bright_rental,miami_gflr_rets,chicago_realtymx,jacksonville_fl_fcmls,nyc_sibor,building,austin_hlmls,bright,portland_or_rmls,sf_ebrd,telluride_tmls,austin_actris,el_paso_gepar,western_ny_wnyreis,dc_bright_rental,olr_vow_bfs,boston_ccimls,denver_summitcountymls_trestle,orlando_daytonamls,sf_mlslistings,miami_re_v2_rets,houston_har,la_trestle_idx_plus,phoenix_armls,naples_bearmls,central_tx_ctxmls,listing_editor_manual,central_tx_ctxmls_trestle,nyc_rls_dla,miami_ramc,philadelphia_momls,olr_sales,miami_trestle_idx_plus,lake_tahoe_stmls,naples_fortmls,lake_tahoe_tsmls,philadelphia_glvrmls,houston_gar,chicago_mls_rets,gamls,olr_rentals,westchester_ny_hgar,denver_recolorado,long_island_mlsli,nyc_bkmls,napmls_rets,memphis_maarmls,seattle_nwmls,la_rowmls,denver_summitcountymls,la_crmls_rets,santa_barbara_montecito_nsbcrmls,nashville_grid_realtracs,hamptons_outeast,chicago_mred_plnmls,RealPlus,nestio}'::text[]))
  • Rows Removed by Filter: 1
13. 238.950 238.950 ↑ 1.0 1 225

Index Scan using propertyinfo_pkey on propertyinfo (cost=0.56..7.20 rows=1 width=1,454) (actual time=1.062..1.062 rows=1 loops=225)

  • Index Cond: (messier_property_id = transactioninfo.property_id)
14. 256.950 256.950 ↑ 1.0 1 225

Index Scan using propertygeocodinginfo_pkey on propertygeocodinginfo (cost=0.56..5.72 rows=1 width=1,157) (actual time=1.142..1.142 rows=1 loops=225)

  • Index Cond: (propertyinfo.uc_address_sha = uc_address_sha)
15. 162.675 162.675 ↑ 1.0 1 225

Index Scan using listingimagesinfo_pkey on listingimagesinfo (cost=0.56..5.69 rows=1 width=586) (actual time=0.723..0.723 rows=1 loops=225)

  • Index Cond: (external_listing_sha = listing.external_listing_sha)
16. 4.950 4.950 ↓ 0.0 0 225

Index Scan using listingnonimagemediainfo_pkey on listingnonimagemediainfo (cost=0.55..5.61 rows=1 width=752) (actual time=0.022..0.022 rows=0 loops=225)

  • Index Cond: (external_listing_sha = listing.external_listing_sha)
17. 0.675 0.675 ↓ 0.0 0 225

Index Scan using transactionmanualinfo_pkey on transactionmanualinfo (cost=0.42..5.48 rows=1 width=1,273) (actual time=0.003..0.003 rows=0 loops=225)

  • Index Cond: (messier_transaction_id = transactioninfo.messier_transaction_id)
18. 0.225 0.225 ↓ 0.0 0 225

Index Scan using transactionnycagentmanualinfo_pkey on transactionnycagentmanualinfo (cost=0.14..4.66 rows=1 width=119) (actual time=0.001..0.001 rows=0 loops=225)

  • Index Cond: (messier_transaction_id = transactioninfo.messier_transaction_id)
19. 0.225 0.225 ↓ 0.0 0 225

Index Scan using transactionbuildingoverride_pkey on transactionbuildingoverride (cost=0.15..2.57 rows=1 width=17) (actual time=0.001..0.001 rows=0 loops=225)

  • Index Cond: (messier_transaction_id = transactioninfo.messier_transaction_id)