explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u84q

Settings
# exclusive inclusive rows x rows loops node
1. 138,092.243 414,885.348 ↑ 1.0 53,500,608 1

Merge Join (cost=392.54..2,579,234.67 rows=53,500,608 width=38) (actual time=574.024..414,885.348 rows=53,500,608 loops=1)

  • Output: ipp.object_id, ipp.property_type_id, ipp.object_source_id, CASE WHEN (ipp.object_source_kind = 'I'::bpchar) THEN 'K'::text WHEN (ipp.object_source_kind = 'E'::bpchar) THEN 'S'::text ELSE NULL::text END, ipp.position_id, ipp.position_index, ipp.line_start, ipp.col_start, ipp.line_end, ipp.col_end
  • Merge Cond: (ao.objectid = ipp.object_id)
  • Buffers: shared hit=15175 read=646298, local hit=381659 read=31017 written=4090
2. 57,538.832 57,538.832 ↑ 1.0 855,627 1

Index Only Scan using idx_amt_objects_objectid on pg_temp_2.amt_objects ao (cost=0.00..42,348.12 rows=855,662 width=4) (actual time=0.020..57,538.832 rows=855,627 loops=1)

  • Output: ao.objectid
  • Heap Fetches: 855627
  • Buffers: local hit=381659 read=31017 written=4090
3. 219,254.273 219,254.273 ↑ 1.0 53,500,608 1

Index Scan using idx_in_prop_positions_object_id on new_fva_local.in_prop_positions ipp (cost=0.00..1,598,544.26 rows=53,500,608 width=38) (actual time=0.020..219,254.273 rows=53,500,608 loops=1)

  • Output: ipp.session_id, ipp.object_id, ipp.property_type_id, ipp.object_source_id, ipp.object_source_kind, ipp.position_id, ipp.position_index, ipp.line_start, ipp.col_start, ipp.line_end, ipp.col_end
  • Filter: (ipp.session_id = 252)
  • Buffers: shared hit=15175 read=646298
Total runtime : 476,317.440 ms