explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AIm7

Settings
# exclusive inclusive rows x rows loops node
1. 32.142 145.848 ↑ 1.7 45,197 1

Nested Loop (cost=1,458.71..816,153.32 rows=76,780 width=10) (actual time=3.680..145.848 rows=45,197 loops=1)

2. 19.871 23.312 ↑ 1.7 45,197 1

Bitmap Heap Scan on slr_in_out_charges u0 (cost=1,458.14..230,049.03 rows=76,814 width=4) (actual time=3.659..23.312 rows=45,197 loops=1)

  • Recheck Cond: (ent_id = ANY ('{3713,3714,3715,3716,3507}'::integer[]))
  • Filter: ((NOT is_death_charge) AND (NOT no_show_charge))
  • Heap Blocks: exact=1843
3. 3.441 3.441 ↑ 1.7 45,197 1

Bitmap Index Scan on slr_in_out_charges_dict_root_ent_id (cost=0.00..1,438.94 rows=76,817 width=0) (actual time=3.441..3.441 rows=45,197 loops=1)

  • Index Cond: (ent_id = ANY ('{3713,3714,3715,3716,3507}'::integer[]))
4. 90.394 90.394 ↑ 1.0 1 45,197

Index Scan using slr_register_calcs_charge_id on slr_register_calcs (cost=0.56..7.62 rows=1 width=10) (actual time=0.002..0.002 rows=1 loops=45,197)

  • Index Cond: (charge_id = u0.id)