explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ssPO

Settings
# exclusive inclusive rows x rows loops node
1. 0.041 11.745 ↑ 1.0 67 1

Nested Loop (cost=10.16..982.71 rows=70 width=8) (actual time=11.362..11.745 rows=67 loops=1)

2. 0.012 11.570 ↑ 1.0 67 1

Nested Loop (cost=9.89..961.68 rows=70 width=8) (actual time=11.349..11.570 rows=67 loops=1)

3. 0.030 11.330 ↑ 1.1 76 1

Bitmap Heap Scan on slr_dict_root (cost=9.46..293.68 rows=80 width=4) (actual time=11.314..11.330 rows=76 loops=1)

  • Recheck Cond: (ent_id = ANY ('{7967,NULL}'::integer[]))
  • Heap Blocks: exact=3
4. 11.300 11.300 ↑ 1.1 76 1

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

  • Index Cond: (ent_id = ANY ('{7967,NULL}'::integer[]))
5. 0.228 0.228 ↑ 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.003..0.003 rows=1 loops=76)

  • Index Cond: (dict_root_id = slr_dict_root.id)
  • Filter: (payment_type_template_id IS NOT NULL)
6. 0.134 0.134 ↑ 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.002..0.002 rows=1 loops=67)

  • Index Cond: (id = slr_payment_type.payment_type_template_id)