explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dBz

Settings
# exclusive inclusive rows x rows loops node
1. 289.881 77,359.047 ↓ 1.0 162,938 1

Hash Join (cost=2,088,573.30..3,752,745.07 rows=156,872 width=22) (actual time=33,560.757..77,359.047 rows=162,938 loops=1)

  • Hash Cond: (g0.igdolkequipementmonturev2id = g1.igdomontureid)
  • Buffers: shared hit=49,944 read=497,846
  • I/O Timings: read=63,581.250
2. 43,546.031 60,147.503 ↑ 1.7 396,151 1

Bitmap Heap Scan on gdogdoequipement g0 (cost=2,013,586.67..3,675,952.05 rows=688,151 width=18) (actual time=16,634.593..60,147.503 rows=396,151 loops=1)

  • Recheck Cond: (((igdoequipementidverres = 0) OR (igdoequipementidverres IS NULL)) AND (((tsgdoequipementdatelivraison >= adddays((('2020-10-15 13:59:40.771879+01'::timestamp with time zone)::date)::timestamp with time zone, '-121'::integer)) AND (igdoequipementtransaction = 1)) OR ((tsgdoequipementdatecommande >= adddays((('2020-10-15 13:59:40.771937+01'::timestamp with time zone)::date)::timestamp with time zone, '-121'::integer)) AND (igdoequipementtransaction = 1))))
  • Rows Removed by Index Recheck: 2,406,876
  • Filter: ((dgdoequipementtotalttc >= '1'::double precision) AND ((tsgdoequipementdatelivraison >= adddays((('2020-10-15 13:59:40.771879+01'::timestamp with time zone)::date)::timestamp with time zone, '-121'::integer)) OR (tsgdoequipementdatecommande >= adddays((('2020-10-15 13:59:40.771937+01'::timestamp with time zone)::date)::timestamp with time zone, '-121'::integer))))
  • Rows Removed by Filter: 68,637
  • Heap Blocks: exact=101,864 lossy=108,878
  • Buffers: shared hit=49,943 read=464,588
  • I/O Timings: read=47,655.366
3. 103.692 16,601.472 ↓ 0.0 0 1

BitmapAnd (cost=2,013,586.67..2,013,586.67 rows=747,366 width=0) (actual time=16,601.472..16,601.472 rows=0 loops=1)

  • Buffers: shared hit=28,493 read=275,296
  • I/O Timings: read=10,238.671
4. 0.004 891.593 ↓ 0.0 0 1

BitmapOr (cost=172,959.35..172,959.35 rows=9,346,418 width=0) (actual time=891.593..891.593 rows=0 loops=1)

  • Buffers: shared hit=1 read=25,534
  • I/O Timings: read=91.403
5. 888.649 888.649 ↑ 1.0 9,342,954 1

Bitmap Index Scan on gdogdoequipement_xeq_ver (cost=0.00..172,610.70 rows=9,346,418 width=0) (actual time=888.649..888.649 rows=9,342,954 loops=1)

  • Index Cond: (igdoequipementidverres = 0)
  • Buffers: shared read=25,531
  • I/O Timings: read=88.481
6. 2.940 2.940 ↓ 0.0 0 1

Bitmap Index Scan on gdogdoequipement_xeq_ver (cost=0.00..4.57 rows=1 width=0) (actual time=2.940..2.940 rows=0 loops=1)

  • Index Cond: (igdoequipementidverres IS NULL)
  • Buffers: shared hit=1 read=3
  • I/O Timings: read=2.921
7. 0.005 15,606.187 ↓ 0.0 0 1

BitmapOr (cost=1,840,627.08..1,840,627.08 rows=2,884,842 width=0) (actual time=15,606.187..15,606.187 rows=0 loops=1)

  • Buffers: shared hit=28,492 read=249,762
  • I/O Timings: read=10,147.269
8. 3,084.525 3,084.525 ↓ 1.1 1,623,319 1

Bitmap Index Scan on t_xeq_ens_dli_nat_typ_1b6cc0e2 (cost=0.00..920,205.50 rows=1,525,004 width=0) (actual time=3,084.525..3,084.525 rows=1,623,319 loops=1)

  • Index Cond: ((tsgdoequipementdatelivraison >= adddays((('2020-10-15 13:59:40.771879+01'::timestamp with time zone)::date)::timestamp with time zone, '-121'::integer)) AND (igdoequipementtransaction = 1))
  • Buffers: shared hit=28,492 read=110,654
  • I/O Timings: read=358.835
9. 12,521.657 12,521.657 ↓ 1.0 1,362,103 1

Bitmap Index Scan on t_xeq_ens_dco_nat_typ_698f0c46 (cost=0.00..920,077.50 rows=1,359,838 width=0) (actual time=12,521.657..12,521.657 rows=1,362,103 loops=1)

  • Index Cond: ((tsgdoequipementdatecommande >= adddays((('2020-10-15 13:59:40.771937+01'::timestamp with time zone)::date)::timestamp with time zone, '-121'::integer)) AND (igdoequipementtransaction = 1))
  • Buffers: shared read=139,108
  • I/O Timings: read=9,788.434
10. 281.102 16,921.663 ↓ 1.0 621,534 1

Hash (cost=67,297.51..67,297.51 rows=615,129 width=4) (actual time=16,921.663..16,921.663 rows=621,534 loops=1)

  • Buckets: 1,048,576 Batches: 1 Memory Usage: 30,043kB
  • Buffers: shared hit=1 read=33,258
  • I/O Timings: read=15,925.884
11. 16,577.363 16,640.561 ↓ 1.0 621,534 1

Bitmap Heap Scan on gdogdomonture g1 (cost=11,678.45..67,297.51 rows=615,129 width=4) (actual time=69.629..16,640.561 rows=621,534 loops=1)

  • Recheck Cond: ((igdolkmonturegefamilleid = 99,686,472) OR (igdolkmonturegefamilleid = 163,285,601))
  • Heap Blocks: exact=31,555
  • Buffers: shared hit=1 read=33,258
  • I/O Timings: read=15,925.884
12. 0.002 63.198 ↓ 0.0 0 1

BitmapOr (cost=11,678.45..11,678.45 rows=615,204 width=0) (actual time=63.198..63.198 rows=0 loops=1)

  • Buffers: shared hit=1 read=1,703
  • I/O Timings: read=30.703
13. 63.179 63.179 ↓ 1.0 621,534 1

Bitmap Index Scan on gdogdomonture_mont_famille (cost=0.00..11,363.99 rows=614,874 width=0) (actual time=63.178..63.179 rows=621,534 loops=1)

  • Index Cond: (igdolkmonturegefamilleid = 99,686,472)
  • Buffers: shared read=1,701
  • I/O Timings: read=30.698
14. 0.017 0.017 ↓ 0.0 0 1

Bitmap Index Scan on gdogdomonture_mont_famille (cost=0.00..6.90 rows=330 width=0) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (igdolkmonturegefamilleid = 163,285,601)
  • Buffers: shared hit=1 read=2
  • I/O Timings: read=0.005