explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1VcD

Settings
# exclusive inclusive rows x rows loops node
1. 893.484 30,132.356 ↑ 11.6 47 1

Hash Join (cost=253,863.89..410,490.46 rows=546 width=92) (actual time=29,278.358..30,132.356 rows=47 loops=1)

  • Hash Cond: (this.revisionhistoryid = this_revisionhistory_application.revisionhistoryid)
2. 0.272 0.371 ↑ 2,324.2 47 1

Bitmap Heap Scan on dbsmstylesupplierrevisionhist this (cost=2,531.16..155,753.63 rows=109,239 width=60) (actual time=0.113..0.371 rows=47 loops=1)

  • Recheck Cond: (smstylesupplierid = '5473641959'::numeric)
  • Heap Blocks: exact=33
3. 0.099 0.099 ↑ 2,324.2 47 1

Bitmap Index Scan on fk_stlsrvsnhs_stls_1369 (cost=0.00..2,503.86 rows=109,239 width=0) (actual time=0.098..0.099 rows=47 loops=1)

  • Index Cond: (smstylesupplierid = '5473641959'::numeric)
4. 3,686.992 29,238.501 ↓ 54.7 5,971,504 1

Hash (cost=249,326.22..249,326.22 rows=109,240 width=20) (actual time=29,238.500..29,238.501 rows=5,971,504 loops=1)

  • Buckets: 65536 (originally 65536) Batches: 128 (originally 2) Memory Usage: 3585kB
5. 22,531.540 25,551.509 ↓ 54.7 5,971,504 1

Bitmap Heap Scan on dbrevisionhistory this_revisionhistory_application (cost=2,531.17..249,326.22 rows=109,240 width=20) (actual time=3,030.203..25,551.509 rows=5,971,504 loops=1)

  • Recheck Cond: (applicationid = '368101737'::numeric)
  • Heap Blocks: exact=41744 lossy=368548
6. 3,019.969 3,019.969 ↓ 200.0 21,847,594 1

Bitmap Index Scan on fk_rvsnhstry_pplctn_0342 (cost=0.00..2,503.86 rows=109,240 width=0) (actual time=3,019.968..3,019.969 rows=21,847,594 loops=1)

  • Index Cond: (applicationid = '368101737'::numeric)
Planning time : 0.229 ms
Execution time : 30,132.849 ms