explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3T5s

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.209 ↑ 1.0 1 1

Nested Loop (cost=3.62..30.61 rows=1 width=32) (actual time=0.084..0.209 rows=1 loops=1)

2.          

Initplan (for Nested Loop)

3. 0.018 0.018 ↑ 1.0 1 1

Index Scan using ix_new_ihs_id_nn on sites_ihs (cost=0.41..2.63 rows=1 width=8) (actual time=0.017..0.018 rows=1 loops=1)

  • Index Cond: (new_ihs_id = 'IHS_JIG_0002B'::text)
4. 0.004 0.082 ↓ 2.5 10 1

Nested Loop (cost=0.71..15.74 rows=4 width=54) (actual time=0.040..0.082 rows=10 loops=1)

5. 0.048 0.048 ↓ 2.5 10 1

Index Scan using idx_gr_entities_entity_id_2 on gr_entities e (cost=0.43..5.76 rows=4 width=4) (actual time=0.034..0.048 rows=10 loops=1)

  • Index Cond: (entity_id = $0)
  • Filter: (ent_type = 'thing'::text)
6. 0.030 0.030 ↑ 1.0 1 10

Index Scan using ix_groups_gr_id on groups t (cost=0.28..2.50 rows=1 width=58) (actual time=0.003..0.003 rows=1 loops=10)

  • Index Cond: (id = e.gr_id)
7. 0.110 0.110 ↓ 0.0 0 10

Index Scan using ix_groups_gr_id on groups g (cost=0.28..3.05 rows=1 width=25) (actual time=0.008..0.011 rows=0 loops=10)

  • Index Cond: (id = ANY (t.path))
  • Filter: (gr_category = 'E_IHS_FSEMN03'::text)
  • Rows Removed by Filter: 6
Planning time : 0.610 ms
Execution time : 0.245 ms