explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0qu0

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 239.347 ↑ 1.0 100 1

Limit (cost=1,004.33..3,710.48 rows=100 width=5,704) (actual time=24.377..239.347 rows=100 loops=1)

2. 0.000 239.329 ↑ 3,495.2 100 1

Gather Merge (cost=1,004.33..9,459,606.56 rows=349,522 width=5,704) (actual time=24.377..239.329 rows=100 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
3. 0.234 1,260.742 ↑ 2,330.2 25 7

Nested Loop Left Join (cost=4.23..9,415,252.88 rows=58,254 width=5,711) (actual time=10.343..180.106 rows=25 loops=7)

4. 0.248 1,260.336 ↑ 2,330.2 25 7

Nested Loop Left Join (cost=4.08..9,265,539.62 rows=58,254 width=5,702) (actual time=10.333..180.048 rows=25 loops=7)

5. 0.138 1,259.916 ↑ 2,330.2 25 7

Nested Loop Left Join (cost=3.93..8,994,075.45 rows=58,254 width=5,591) (actual time=10.325..179.988 rows=25 loops=7)

6. 0.270 1,259.090 ↑ 2,330.2 25 7

Nested Loop Left Join (cost=3.51..8,674,654.43 rows=58,254 width=4,326) (actual time=10.313..179.870 rows=25 loops=7)

7. 0.402 1,251.768 ↑ 2,330.2 25 7

Nested Loop Left Join (cost=2.96..8,347,908.31 rows=58,254 width=3,656) (actual time=10.293..178.824 rows=25 loops=7)

8. 0.457 1,122.366 ↑ 2,330.2 25 7

Nested Loop Left Join (cost=2.40..8,016,363.15 rows=58,254 width=3,111) (actual time=9.381..160.338 rows=25 loops=7)

9. 0.324 938.385 ↑ 2,330.2 25 7

Nested Loop (cost=1.83..7,683,210.48 rows=58,254 width=2,036) (actual time=8.351..134.055 rows=25 loops=7)

10. 0.697 736.477 ↑ 2,330.2 25 7

Nested Loop (cost=1.27..7,264,042.65 rows=58,254 width=598) (actual time=7.464..105.211 rows=25 loops=7)

11. 150.780 150.780 ↑ 3,124.2 74 7

Parallel Index Scan using transactioninfo_primary_external_listing_sha_idx on transactioninfo (cost=0.70..5,534,607.78 rows=231,189 width=565) (actual time=4.685..21.540 rows=74 loops=7)

  • Index Cond: ((primary_external_listing_sha > 'd5675696eef07cfa277c1c8c5ea68fa6194fb696'::bpchar) AND (primary_external_listing_sha < 'd7b425ed'::bpchar))
12. 585.000 585.000 ↓ 0.0 0 520

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

  • 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. 201.584 201.584 ↑ 1.0 1 172

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

  • Index Cond: (messier_property_id = transactioninfo.property_id)
14. 183.524 183.524 ↑ 1.0 1 172

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

  • Index Cond: (propertyinfo.uc_address_sha = uc_address_sha)
15. 129.000 129.000 ↑ 1.0 1 172

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

  • Index Cond: (external_listing_sha = listing.external_listing_sha)
16. 7.052 7.052 ↓ 0.0 0 172

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

  • Index Cond: (external_listing_sha = listing.external_listing_sha)
17. 0.688 0.688 ↓ 0.0 0 172

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

  • Index Cond: (messier_transaction_id = transactioninfo.messier_transaction_id)
18. 0.172 0.172 ↓ 0.0 0 172

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=172)

  • Index Cond: (messier_transaction_id = transactioninfo.messier_transaction_id)
19. 0.172 0.172 ↓ 0.0 0 172

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=172)

  • Index Cond: (messier_transaction_id = transactioninfo.messier_transaction_id)
Planning time : 11.438 ms
Execution time : 239.531 ms