explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 23Gh

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 9.857 ↑ 10.0 1 1

Nested Loop (cost=44.66..1,613.20 rows=10 width=32) (actual time=5.215..9.857 rows=1 loops=1)

2. 0.003 9.821 ↑ 1.0 1 1

Nested Loop (cost=44.37..1,612.52 rows=1 width=29) (actual time=5.180..9.821 rows=1 loops=1)

3. 0.073 0.073 ↑ 1.0 1 1

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

  • Index Cond: (new_ihs_id = 'IHS_JIG_0002B'::text)
4. 0.369 9.745 ↑ 470.0 1 1

Nested Loop (cost=43.95..1,605.19 rows=470 width=36) (actual time=5.105..9.745 rows=1 loops=1)

5. 1.339 7.933 ↓ 1.0 481 1

Hash Join (cost=43.52..867.29 rows=470 width=33) (actual time=0.239..7.933 rows=481 loops=1)

  • Hash Cond: ((((unnest(string_to_array(groups.gr_path, '->'::text, ','::text))))::integer) = g.id)
6. 2.363 6.520 ↑ 1.2 15,049 1

Result (cost=0.00..596.92 rows=17,960 width=40) (actual time=0.013..6.520 rows=15,049 loops=1)

7. 3.844 4.157 ↑ 1.2 15,049 1

ProjectSet (cost=0.00..237.72 rows=17,960 width=36) (actual time=0.011..4.157 rows=15,049 loops=1)

8. 0.313 0.313 ↑ 1.0 1,796 1

Seq Scan on groups (cost=0.00..129.96 rows=1,796 width=50) (actual time=0.004..0.313 rows=1,796 loops=1)

9. 0.017 0.074 ↑ 1.0 46 1

Hash (cost=42.93..42.93 rows=47 width=25) (actual time=0.074..0.074 rows=46 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
10. 0.035 0.057 ↑ 1.0 46 1

Bitmap Heap Scan on groups g (cost=1.74..42.93 rows=47 width=25) (actual time=0.028..0.057 rows=46 loops=1)

  • Recheck Cond: (gr_category = 'E_IHS_FSEMN03'::text)
  • Heap Blocks: exact=12
11. 0.022 0.022 ↑ 1.0 46 1

Bitmap Index Scan on idx_groups_category (cost=0.00..1.73 rows=47 width=0) (actual time=0.022..0.022 rows=46 loops=1)

  • Index Cond: (gr_category = 'E_IHS_FSEMN03'::text)
12. 1.443 1.443 ↓ 0.0 0 481

Index Only Scan using uq_gr_id_type_text on gr_entities e (cost=0.44..1.56 rows=1 width=11) (actual time=0.003..0.003 rows=0 loops=481)

  • Index Cond: ((gr_id = groups.id) AND (ent_type = 'thing'::text) AND (ent_text = (s.id)::text))
  • Heap Fetches: 0
13. 0.029 0.029 ↑ 13.0 1 1

Index Only Scan using fki_gr_id_groups_id on gr_user_groups gru (cost=0.29..0.52 rows=13 width=4) (actual time=0.028..0.029 rows=1 loops=1)

  • Index Cond: (gr_id = (((unnest(string_to_array(groups.gr_path, '->'::text, ','::text))))::integer))
  • Heap Fetches: 1
Planning time : 1.356 ms
Execution time : 9.982 ms