explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eCbu

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 2,260.108 ↑ 1.0 1 1

Nested Loop (cost=1.13..13.84 rows=1 width=508) (actual time=2,260.102..2,260.108 rows=1 loops=1)

2. 0.002 0.038 ↑ 1.0 1 1

Nested Loop (cost=0.72..9.52 rows=1 width=476) (actual time=0.033..0.038 rows=1 loops=1)

3. 0.012 0.033 ↑ 1.0 1 1

Nested Loop (cost=0.57..5 rows=1 width=476) (actual time=0.028..0.033 rows=1 loops=1)

4. 0.016 0.016 ↑ 1.0 1 1

Index Scan using user_vendor_id_key on user user (cost=0.28..2.5 rows=1 width=394) (actual time=0.011..0.016 rows=1 loops=1)

  • Index Cond: ((vendor_id)::text = '18004240'::text)
5. 0.005 0.005 ↑ 1.0 1 1

Index Scan using entity_pkey on entity entity (cost=0.29..2.51 rows=1 width=82) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (id = "user".id)
6. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.15..4.48 rows=4 width=32) (actual time=0.003..0.003 rows=0 loops=1)

7. 0.003 0.003 ↓ 0.0 0 1

Index Scan using identity_read_permission_negative_entity_permission_id_idx on identity_read_permission_negative identity_read_permission_negative (cost=0.15..0.22 rows=4 width=64) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (entity_permission_id = entity.permission_id)
8. 0.000 0.000 ↓ 0.0 0 0

Materialize (cost=0..2.41 rows=19 width=18) (never executed)

9. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on permission_identity_expansion_cache permission_identity_expansion_cache_1 (cost=0..2.31 rows=19 width=18) (never executed)

  • Filter: (base = 'pr.system_admin'::text)
10. 2,259.785 2,260.051 ↑ 1.0 1 1

Nested Loop (cost=0.41..4.3 rows=1 width=13) (actual time=2,260.051..2,260.051 rows=1 loops=1)

11. 0.031 0.031 ↓ 1.7 5 1

Index Scan using identity_read_permission_entity_permission_id_idx on identity_read_permission identity_read_permission (cost=0.41..0.51 rows=3 width=31) (actual time=0.009..0.031 rows=5 loops=1)

  • Index Cond: (entity_permission_id = entity.permission_id)
12. 0.136 0.235 ↑ 1.1 17 5

Materialize (cost=0..2.41 rows=19 width=18) (actual time=0.003..0.047 rows=17 loops=5)

13. 0.099 0.099 ↓ 1.1 21 1

Seq Scan on permission_identity_expansion_cache permission_identity_expansion_cache (cost=0..2.31 rows=19 width=18) (actual time=0.008..0.099 rows=21 loops=1)

  • Filter: (base = 'pr.system_admin'::text)
Planning time : 5.304 ms
Execution time : 2,261.594 ms