explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NeaV

Settings
# exclusive inclusive rows x rows loops node
1. 1.324 374.236 ↓ 188.0 188 1

Nested Loop Left Join (cost=71.46..533.00 rows=1 width=383) (actual time=0.776..374.236 rows=188 loops=1)

2. 0.109 372.536 ↓ 188.0 188 1

Nested Loop Left Join (cost=71.31..532.53 rows=1 width=355) (actual time=0.758..372.536 rows=188 loops=1)

3. 0.176 372.051 ↓ 188.0 188 1

Nested Loop Left Join (cost=71.16..532.15 rows=1 width=351) (actual time=0.756..372.051 rows=188 loops=1)

4. 0.185 187.071 ↓ 188.0 188 1

Nested Loop Left Join (cost=70.46..312.54 rows=1 width=345) (actual time=0.572..187.071 rows=188 loops=1)

5. 0.159 2.458 ↓ 188.0 188 1

Nested Loop (cost=69.76..92.93 rows=1 width=339) (actual time=0.089..2.458 rows=188 loops=1)

6. 0.180 2.111 ↓ 188.0 188 1

Nested Loop (cost=69.61..92.72 rows=1 width=311) (actual time=0.087..2.111 rows=188 loops=1)

7. 0.168 1.743 ↓ 188.0 188 1

Nested Loop (cost=69.46..92.51 rows=1 width=283) (actual time=0.084..1.743 rows=188 loops=1)

8. 0.081 1.387 ↓ 188.0 188 1

Nested Loop (cost=69.31..92.30 rows=1 width=255) (actual time=0.081..1.387 rows=188 loops=1)

9. 0.211 0.930 ↓ 188.0 188 1

Nested Loop (cost=69.15..92.09 rows=1 width=263) (actual time=0.069..0.930 rows=188 loops=1)

10. 0.170 0.531 ↓ 188.0 188 1

Hash Join (cost=69.00..91.89 rows=1 width=255) (actual time=0.063..0.531 rows=188 loops=1)

  • Hash Cond: ((em.endpoint_software_version_id = f.endpoint_software_version_id) AND (e.firmware_id = f.id))
11. 0.260 0.344 ↑ 1.0 188 1

Hash Join (cost=48.25..69.72 rows=188 width=191) (actual time=0.030..0.344 rows=188 loops=1)

  • Hash Cond: (e.endpoint_meta_id = em.id)
12. 0.071 0.071 ↑ 1.0 188 1

Seq Scan on endpoint e (cost=0.00..18.88 rows=188 width=187) (actual time=0.001..0.071 rows=188 loops=1)

13. 0.008 0.013 ↑ 89.5 19 1

Hash (cost=27.00..27.00 rows=1,700 width=12) (actual time=0.013..0.013 rows=19 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 17kB
14. 0.005 0.005 ↑ 89.5 19 1

Seq Scan on endpoint_meta em (cost=0.00..27.00 rows=1,700 width=12) (actual time=0.002..0.005 rows=19 loops=1)

15. 0.014 0.017 ↑ 430.0 1 1

Hash (cost=14.30..14.30 rows=430 width=72) (actual time=0.017..0.017 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
16. 0.003 0.003 ↑ 430.0 1 1

Seq Scan on firmware f (cost=0.00..14.30 rows=430 width=72) (actual time=0.003..0.003 rows=1 loops=1)

17. 0.188 0.188 ↑ 1.0 1 188

Index Scan using pk_endpoint_class on endpoint_class ec (cost=0.15..0.20 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=188)

  • Index Cond: (id = em.endpoint_class_id)
18. 0.376 0.376 ↑ 1.0 1 188

Index Only Scan using pk_endpoint_software_version on endpoint_software_version esv (cost=0.15..0.20 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=188)

  • Index Cond: (id = em.endpoint_software_version_id)
  • Heap Fetches: 188
19. 0.188 0.188 ↑ 1.0 1 188

Index Scan using pk_endpoint_family_type on endpoint_family_type eft (cost=0.15..0.20 rows=1 width=36) (actual time=0.001..0.001 rows=1 loops=188)

  • Index Cond: (id = ec.endpoint_family_type_id)
20. 0.188 0.188 ↑ 1.0 1 188

Index Scan using pk_endpoint_device_type on endpoint_device_type edt (cost=0.15..0.20 rows=1 width=36) (actual time=0.001..0.001 rows=1 loops=188)

  • Index Cond: (id = ec.endpoint_device_type_id)
21. 0.188 0.188 ↑ 1.0 1 188

Index Scan using pk_endpoint_display_type on endpoint_display_type edis (cost=0.15..0.20 rows=1 width=36) (actual time=0.001..0.001 rows=1 loops=188)

  • Index Cond: (id = ec.endpoint_display_type_id)
22. 60.536 184.428 ↑ 1.0 1 188

Nested Loop (cost=0.70..219.60 rows=1 width=10) (actual time=0.648..0.981 rows=1 loops=188)

23. 18.612 18.612 ↓ 1.0 560 188

Index Scan using idx_endpoint_property_endpoint_id on endpoint_property epp_1 (cost=0.42..40.49 rows=556 width=14) (actual time=0.010..0.099 rows=560 loops=188)

  • Index Cond: (endpoint_id = e.id)
24. 105.280 105.280 ↓ 0.0 0 105,280

Index Scan using pk_property_meta on property_meta pm_1 (cost=0.28..0.31 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=105,280)

  • Index Cond: (id = epp_1.property_meta_id)
  • Filter: ((path)::text = 'urn:pcoip:firmware/pcoip_processor_state/serial'::text)
  • Rows Removed by Filter: 1
25. 61.664 184.804 ↑ 1.0 1 188

Nested Loop (cost=0.70..219.60 rows=1 width=10) (actual time=0.311..0.983 rows=1 loops=188)

26. 17.860 17.860 ↓ 1.0 560 188

Index Scan using idx_endpoint_property_endpoint_id on endpoint_property epp (cost=0.42..40.49 rows=556 width=14) (actual time=0.008..0.095 rows=560 loops=188)

  • Index Cond: (endpoint_id = e.id)
27. 105.280 105.280 ↓ 0.0 0 105,280

Index Scan using pk_property_meta on property_meta pm (cost=0.28..0.31 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=105,280)

  • Index Cond: (id = epp.property_meta_id)
  • Filter: ((path)::text = 'urn:pcoip:identity/software_build_state/build_id'::text)
  • Rows Removed by Filter: 1
28. 0.376 0.376 ↑ 1.0 1 188

Index Scan using uq_autoconfig_assignment_endpoint_id on autoconfig_assignment a (cost=0.14..0.38 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=188)

  • Index Cond: (e.id = endpoint_id)
29. 0.376 0.376 ↑ 1.0 1 188

Index Scan using pk_autoconfig_status_type on autoconfig_status_type t (cost=0.15..0.43 rows=1 width=36) (actual time=0.002..0.002 rows=1 loops=188)

  • Index Cond: (a.autoconfig_status_type_id = id)
Planning time : 7.146 ms
Execution time : 374.656 ms