explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Smtn

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=64,785.71..5,036,531.37 rows=238,095 width=334) (actual rows= loops=)

  • Hash Cond: (insta.insta_bod_clsub_id = sb.clsub_id)
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=59,674.45..5,016,836.79 rows=238,095 width=507) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=59,673.88..3,024,682.26 rows=238,095 width=493) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on daraw_opera_operation ope1 (cost=59,673.31..997,534.79 rows=238,095 width=484) (actual rows= loops=)

  • Recheck Cond: ((opera_operation_date_tz >= '2019-06-01 00:00:00+02'::timestamp with time zone) AND (opera_operation_date_tz < '2019-06-02 00:00:00+02'::timestamp with time zone) AND ((opera_gener_cntry_id)::text = 'FR'::text) AND (opera_bod_opsta_id = 2))
  • Filter: ((opera_del_date IS NULL) AND (((opera_data -> 'simulated'::text) IS NULL) OR ((opera_data -> 'simulated'::text) <> '1'::text)))
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_bi_190605 (cost=0.00..59,613.78 rows=240,015 width=0) (actual rows= loops=)

  • Index Cond: ((opera_operation_date_tz >= '2019-06-01 00:00:00+02'::timestamp with time zone) AND (opera_operation_date_tz < '2019-06-02 00:00:00+02'::timestamp with time zone) AND ((opera_gener_cntry_id)::text = 'FR'::text) AND (opera_bod_opsta_id = 2))
6. 0.000 0.000 ↓ 0.0

Index Scan using idx_bilit_opera_id_190604 on daraw_bilit_billed_item (cost=0.58..8.50 rows=1 width=25) (actual rows= loops=)

  • Index Cond: (bilit_opera_id = ope1.opera_id)
  • Filter: (bilit_del_date IS NULL)
7. 0.000 0.000 ↓ 0.0

Index Scan using pk_insta on daraw_insta_instance insta (cost=0.57..8.36 rows=1 width=30) (actual rows= loops=)

  • Index Cond: (insta_id = ope1.opera_insta_id)
8. 0.000 0.000 ↓ 0.0

Hash (cost=3,429.45..3,429.45 rows=134,545 width=28) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on bod_clsub_client_sub_service sb (cost=0.00..3,429.45 rows=134,545 width=28) (actual rows= loops=)