explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K82H

Settings
# exclusive inclusive rows x rows loops node
1. 0.058 0.950 ↑ 1.0 67 1

Nested Loop (cost=5.74..978.29 rows=70 width=8) (actual time=0.083..0.950 rows=67 loops=1)

2. 0.090 0.624 ↑ 1.0 67 1

Nested Loop (cost=5.46..957.26 rows=70 width=8) (actual time=0.073..0.624 rows=67 loops=1)

3. 0.047 0.078 ↑ 1.1 76 1

Bitmap Heap Scan on slr_dict_root (cost=5.04..289.26 rows=80 width=4) (actual time=0.042..0.078 rows=76 loops=1)

  • Recheck Cond: (ent_id = 7967)
  • Heap Blocks: exact=3
4. 0.031 0.031 ↑ 1.1 76 1

Bitmap Index Scan on slr_dict_ro_ent_id_e5aeb6_idx (cost=0.00..5.02 rows=80 width=0) (actual time=0.031..0.031 rows=76 loops=1)

  • Index Cond: (ent_id = 7967)
5. 0.456 0.456 ↑ 1.0 1 76

Index Scan using slr_payment_type_dict_root_id on slr_payment_type (cost=0.42..8.34 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=76)

  • Index Cond: (dict_root_id = slr_dict_root.id)
  • Filter: (payment_type_template_id IS NOT NULL)
6. 0.268 0.268 ↑ 1.0 1 67

Index Scan using slr_payment_type_template_pkey on slr_payment_type_template (cost=0.27..0.29 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=67)

  • Index Cond: (id = slr_payment_type.payment_type_template_id)