explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x8CM

Settings
# exclusive inclusive rows x rows loops node
1. 0.423 171,425.185 ↑ 11.6 47 1

Nested Loop (cost=254,077.45..414,545.30 rows=546 width=112) (actual time=165,264.909..171,425.185 rows=47 loops=1)

2. 6,239.990 171,406.056 ↑ 11.6 47 1

Hash Join (cost=254,076.89..410,916.46 rows=546 width=100) (actual time=165,263.810..171,406.056 rows=47 loops=1)

  • Hash Cond: (this.revisionhistoryid = this_revisionhistory_application.revisionhistoryid)
3. 16.130 16.189 ↑ 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.069..16.189 rows=47 loops=1)

  • Recheck Cond: (smstylesupplierid = '5473641959'::numeric)
  • Heap Blocks: exact=33
4. 0.059 0.059 ↑ 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.058..0.059 rows=47 loops=1)

  • Index Cond: (smstylesupplierid = '5473641959'::numeric)
5. 16,140.789 165,149.877 ↓ 200.0 21,847,585 1

Hash (cost=249,326.22..249,326.22 rows=109,240 width=40) (actual time=165,149.877..165,149.877 rows=21,847,585 loops=1)

  • Buckets: 65536 (originally 65536) Batches: 512 (originally 4) Memory Usage: 3585kB
6. 146,059.190 149,009.088 ↓ 200.0 21,847,585 1

Bitmap Heap Scan on dbrevisionhistory this_revisionhistory_application (cost=2,531.17..249,326.22 rows=109,240 width=40) (actual time=2,960.276..149,009.088 rows=21,847,585 loops=1)

  • Recheck Cond: (applicationid = '368101737'::numeric)
  • Heap Blocks: exact=41744 lossy=368548
7. 2,949.898 2,949.898 ↓ 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=2,949.898..2,949.898 rows=21,847,594 loops=1)

  • Index Cond: (applicationid = '368101737'::numeric)
8. 18.706 18.706 ↑ 1.0 1 47

Index Scan using pk_rvsnhstry on dbrevisionhistory this_revisionhistory_task (cost=0.56..6.64 rows=1 width=40) (actual time=0.397..0.398 rows=1 loops=47)

  • Index Cond: (revisionhistoryid = this.revisionhistoryid)
Planning time : 0.397 ms
Execution time : 171,425.648 ms