explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DKF3

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.206 ↑ 1.0 1 1

Nested Loop (cost=3.62..30.60 rows=1 width=32) (actual time=0.077..0.206 rows=1 loops=1)

2.          

Initplan (for Nested Loop)

3. 0.017 0.017 ↑ 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.016..0.017 rows=1 loops=1)

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

Nested Loop (cost=0.71..15.73 rows=4 width=54) (actual time=0.036..0.077 rows=10 loops=1)

5. 0.044 0.044 ↓ 2.5 10 1

Index Scan using idx_gr_entities_entity_id_2 on gr_entities e (cost=0.43..5.75 rows=4 width=4) (actual time=0.030..0.044 rows=10 loops=1)

  • Index Cond: (entity_id = $0)
6. 0.020 0.020 ↑ 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.002..0.002 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.545 ms
Execution time : 0.239 ms