explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GaGx

Settings
# exclusive inclusive rows x rows loops node
1. 510.453 10,029.506 ↑ 4.0 608,578 1

Nested Loop (cost=432,135.51..517,670.69 rows=2,450,814 width=68) (actual time=3,533.949..10,029.506 rows=608,578 loops=1)

  • Join Filter: (tb_core_process.id_process = tb_core_process_customer_data.id_process)
2. 619.990 5,259.007 ↓ 6.5 608,578 1

Merge Join (cost=432,135.08..448,459.89 rows=92,921 width=59) (actual time=3,533.850..5,259.007 rows=608,578 loops=1)

  • Merge Cond: ((tb_core_import_request.seq_customer = tb_core_process_checklist.seq_customer) AND (tb_core_process.id_process = tb_core_process_checklist.id_process))
3. 2,042.956 3,020.355 ↑ 1.9 854,821 1

Sort (cost=294,163.49..298,178.76 rows=1,606,109 width=43) (actual time=2,267.891..3,020.355 rows=854,821 loops=1)

  • Sort Key: tb_core_import_request.seq_customer, tb_core_process.id_process
  • Sort Method: external merge Disk: 51,784kB
4. 365.410 977.399 ↑ 1.9 854,821 1

Hash Join (cost=45.72..79,203.20 rows=1,606,109 width=43) (actual time=0.699..977.399 rows=854,821 loops=1)

  • Hash Cond: (tb_core_import_request.id_process = tb_core_process.id_process)
5. 611.362 611.362 ↑ 1.9 943,884 1

Seq Scan on tb_core_import_request (cost=0.00..56,390.60 rows=1,788,208 width=24) (actual time=0.026..611.362 rows=943,884 loops=1)

  • Filter: (id_contract = 39)
6. 0.165 0.627 ↓ 1.0 631 1

Hash (cost=37.86..37.86 rows=629 width=19) (actual time=0.627..0.627 rows=631 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 43kB
7. 0.462 0.462 ↓ 1.0 631 1

Seq Scan on tb_core_process (cost=0.00..37.86 rows=629 width=19) (actual time=0.011..0.462 rows=631 loops=1)

  • Filter: (id_contract = 39)
8. 1,026.681 1,618.662 ↓ 1.0 612,232 1

Sort (cost=137,971.18..139,497.13 rows=610,378 width=16) (actual time=1,265.941..1,618.662 rows=612,232 loops=1)

  • Sort Key: tb_core_process_checklist.seq_customer, tb_core_process_checklist.id_process
  • Sort Method: external sort Disk: 20,360kB
9. 443.151 591.981 ↓ 1.0 612,232 1

Bitmap Heap Scan on tb_core_process_checklist (cost=25,859.14..79,315.86 rows=610,378 width=16) (actual time=153.694..591.981 rows=612,232 loops=1)

  • Recheck Cond: ((is_checked AND is_system_check AND ((cd_backofficer_assignment)::text = 'IMPDEFIN'::text)) OR (is_checked AND is_system_check AND ((cd_backofficer_assignment)::text = 'IMPVALEBROKER'::text)))
  • Filter: (is_checked AND is_system_check AND (id_contract = 39))
  • Heap Blocks: exact=17,951
10. 0.003 148.830 ↓ 0.0 0 1

BitmapOr (cost=25,859.14..25,859.14 rows=731,927 width=0) (actual time=148.830..148.830 rows=0 loops=1)

11. 77.027 77.027 ↑ 1.1 326,508 1

Bitmap Index Scan on tb_core_process_checklist_idx01_2 (cost=0.00..12,761.01 rows=365,486 width=0) (actual time=77.027..77.027 rows=326,508 loops=1)

  • Index Cond: ((is_checked = true) AND (is_system_check = true) AND ((cd_backofficer_assignment)::text = 'IMPDEFIN'::text))
12. 71.800 71.800 ↑ 1.3 292,396 1

Bitmap Index Scan on tb_core_process_checklist_idx01_2 (cost=0.00..12,792.94 rows=366,441 width=0) (actual time=71.800..71.800 rows=292,396 loops=1)

  • Index Cond: ((is_checked = true) AND (is_system_check = true) AND ((cd_backofficer_assignment)::text = 'IMPVALEBROKER'::text))
13. 4,260.046 4,260.046 ↑ 1.0 1 608,578

Index Scan using tb_core_process_customer_data_pk on tb_core_process_customer_data (cost=0.42..0.73 rows=1 width=57) (actual time=0.006..0.007 rows=1 loops=608,578)

  • Index Cond: ((id_process = tb_core_import_request.id_process) AND (id_contract = 39) AND (seq_customer = tb_core_import_request.seq_customer))
  • Filter: (id_customer IS NOT NULL)
Planning time : 6.868 ms
Execution time : 10,175.969 ms