explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3sli

Settings
# exclusive inclusive rows x rows loops node
1. 273.146 273.146 ↓ 1,000.0 1,000 1

CTE Scan on certificates (cost=145,329.76..145,329.78 rows=1 width=328) (actual time=272.063..273.146 rows=1,000 loops=1)

2.          

CTE certificates

3. 0.000 272.744 ↓ 1,000.0 1,000 1

Limit (cost=145,322.05..145,329.76 rows=1 width=116) (actual time=272.059..272.744 rows=1,000 loops=1)

4. 24.459 274.801 ↓ 6.1 91,000 1

Gather (cost=29,424.07..145,322.05 rows=15,015 width=116) (actual time=144.648..274.801 rows=91,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 83.138 250.342 ↓ 4.8 30,337 3 / 3

Parallel Hash Join (cost=28,424.07..142,820.55 rows=6,256 width=116) (actual time=141.160..250.342 rows=30,337 loops=3)

  • Hash Cond: ((tb_dist_certificate_daily.id_customer = tb_dist_certificate.id_customer) AND (tb_dist_certificate_daily.id_instrument = tb_dist_certificate.id_instrument) AND (tb_dist_certificate_daily.id_certificate = tb_dist_certificate.id_certificate))
6. 27.134 27.134 ↑ 1.4 74,440 3 / 3

Parallel Index Scan using tb_dist_certificate_daily_id_contract_dt_reference_idx on tb_dist_certificate_daily (cost=0.57..113,488.33 rows=105,462 width=78) (actual time=0.041..27.134 rows=74,440 loops=3)

  • Index Cond: ((id_contract = 8) AND (dt_reference = 20,200,601))
7. 40.481 140.070 ↑ 1.3 83,182 3 / 3

Parallel Hash (cost=26,599.46..26,599.46 rows=104,231 width=42) (actual time=140.070..140.070 rows=83,182 loops=3)

  • Buckets: 262,144 Batches: 1 Memory Usage: 21,824kB
8. 99.589 99.589 ↑ 1.3 83,182 3 / 3

Parallel Seq Scan on tb_dist_certificate (cost=0.00..26,599.46 rows=104,231 width=42) (actual time=0.010..99.589 rows=83,182 loops=3)

  • Filter: ((NOT is_from_minicom) AND (id_contract = 8))
  • Rows Removed by Filter: 362,352