explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nkfz

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 631.880 ↓ 16.0 16 1

Merge Join (cost=6,453.72..28,864.09 rows=1 width=23) (actual time=631.784..631.880 rows=16 loops=1)

  • Merge Cond: (ftlx.feature_type_id = npt.id)
2. 0.087 631.854 ↓ 16.0 32 1

Nested Loop (cost=6,452.17..51,272.70 rows=2 width=27) (actual time=631.728..631.854 rows=32 loops=1)

  • Join Filter: (pftx.layer_info_id = ftlx.layer_info_id)
  • Rows Removed by Join Filter: 1376
3. 0.015 0.015 ↓ 1.2 44 1

Index Only Scan using feature_types_layers_xref_feature_type_id_layer_info_id_key on feature_types_layers_xref ftlx (cost=0.14..8.68 rows=36 width=8) (actual time=0.005..0.015 rows=44 loops=1)

  • Heap Fetches: 44
4. 0.096 631.752 ↓ 16.0 32 44

Materialize (cost=6,452.03..51,262.94 rows=2 width=27) (actual time=5.805..14.358 rows=32 loops=44)

5. 0.822 631.656 ↓ 16.0 32 1

Nested Loop (cost=6,452.03..51,262.93 rows=2 width=27) (actual time=255.400..631.656 rows=32 loops=1)

6. 0.149 629.346 ↓ 124.0 1,488 1

Nested Loop (cost=6,451.60..51,127.57 rows=12 width=23) (actual time=179.955..629.346 rows=1,488 loops=1)

7. 0.013 0.013 ↑ 1.0 1 1

Seq Scan on attribute_names an (cost=0.00..1.99 rows=1 width=4) (actual time=0.005..0.013 rows=1 loops=1)

  • Filter: ((name)::text = 'ID'::text)
  • Rows Removed by Filter: 123
8. 571.639 629.184 ↓ 22.9 1,488 1

Bitmap Heap Scan on network_point_attributes npa (cost=6,451.60..51,124.93 rows=65 width=27) (actual time=179.949..629.184 rows=1,488 loops=1)

  • Recheck Cond: (attribute_names_id = an.id)
  • Filter: ((value)::text = ANY ('{5738B588-83EF-424A-8DF0-EA5119157076,738113FC-4F99-42D0-970C-AB9DA75BFD08,2ECAC90B-8B0E-4402-B90F-B0E1657249D0,BB7497F5-E2BD-42C2-ADBF-E06FA5A98F28,2A4391F0-AEB4-4C44-AFCC-77510115B7AC,700390E4-C911-4238-A3F2-320E573E4A68,184F916C-E6FE-403B-950B-4EB141853A3D,F7D8FCAC-C052-4927-9274-4A65016C9CCF,8FA18636-695B-45B4-80F8-B63686155AA9,A3CB91FB-9C3B-444A-AFAD-1AB499912D76,7E11286F-44E4-4995-9F73-04E37849350D,C9FD7A56-BD54-473B-B7FE-45F62D362B5D,5404CA79-B825-4FD0-ACB0-7FFF0626945F,38AB1026-517C-47A2-B738-DD5BDF367DE5,C18512F8-A6D5-4F8B-B24F-CAFFAA61F7BD,A1994087-9A12-49B0-BBD6-0B67FD2AA60D}'::text[]))
  • Rows Removed by Filter: 1574036
  • Heap Blocks: exact=14773
9. 57.545 57.545 ↓ 5.2 1,575,976 1

Bitmap Index Scan on network_point_attributes_attribute_names_id_idx (cost=0.00..6,451.59 rows=300,687 width=0) (actual time=57.545..57.545 rows=1,575,976 loops=1)

  • Index Cond: (attribute_names_id = an.id)
10. 1.488 1.488 ↓ 0.0 0 1,488

Index Scan using plans_features_types_xref_feature_id_idx on plans_features_types_xref pftx (cost=0.43..11.27 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1,488)

  • Index Cond: (feature_id = npa.network_points_id)
  • Filter: ((plan_id IS NOT NULL) AND (deleted_by IS NULL))
  • Rows Removed by Filter: 1
11. 0.011 0.019 ↑ 1.2 15 1

Sort (cost=1.56..1.60 rows=18 width=4) (actual time=0.019..0.019 rows=15 loops=1)

  • Sort Key: npt.id
  • Sort Method: quicksort Memory: 25kB
12. 0.008 0.008 ↓ 1.2 21 1

Seq Scan on network_point_types npt (cost=0.00..1.18 rows=18 width=4) (actual time=0.006..0.008 rows=21 loops=1)

Planning time : 0.725 ms
Execution time : 631.920 ms