explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pMz2

Settings
# exclusive inclusive rows x rows loops node
1. 183.558 88,477.511 ↑ 1.0 1 1

Aggregate (cost=185,135.71..185,135.72 rows=1 width=0) (actual time=88,477.510..88,477.511 rows=1 loops=1)

2. 2,360.715 88,293.953 ↓ 1.0 378,859 1

Hash Right Join (cost=137,919.37..184,194.67 rows=376,417 width=0) (actual time=68,108.910..88,293.953 rows=378,859 loops=1)

  • Hash Cond: (tc.id_contract = contr.id_contract)
3. 17,827.897 17,827.897 ↑ 1.0 1,042,412 1

Seq Scan on tax_contr tc (cost=0.00..38,602.12 rows=1,042,412 width=8) (actual time=3.174..17,827.897 rows=1,042,412 loops=1)

4. 405.261 68,105.341 ↓ 1.0 378,859 1

Hash (cost=133,214.15..133,214.15 rows=376,417 width=8) (actual time=68,105.341..68,105.341 rows=378,859 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 14800kB
5. 2,744.352 67,700.080 ↓ 1.0 378,859 1

Hash Join (cost=52,874.60..133,214.15 rows=376,417 width=8) (actual time=36,290.261..67,700.080 rows=378,859 loops=1)

  • Hash Cond: (contr.id_contract = mo.id_contract)
6. 28,665.971 28,665.971 ↑ 1.0 1,042,419 1

Seq Scan on contr (cost=0.00..66,151.19 rows=1,042,419 width=8) (actual time=0.038..28,665.971 rows=1,042,419 loops=1)

7. 315.222 36,289.757 ↓ 1.0 378,859 1

Hash (cost=48,169.39..48,169.39 rows=376,417 width=8) (actual time=36,289.757..36,289.757 rows=378,859 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 14800kB
8. 324.710 35,974.535 ↓ 1.0 378,859 1

Hash Left Join (cost=34.28..48,169.39 rows=376,417 width=8) (actual time=0.180..35,974.535 rows=378,859 loops=1)

  • Hash Cond: (mo.id_account = cntz.id_account)
9. 325.896 35,649.823 ↓ 1.0 378,859 1

Hash Anti Join (cost=1.32..46,630.80 rows=376,417 width=16) (actual time=0.149..35,649.823 rows=378,859 loops=1)

  • Hash Cond: (mo.id_account = uls.id_account)
10. 35,323.846 35,323.846 ↓ 1.0 378,859 1

Seq Scan on modulo_owner mo (cost=0.00..41,876.86 rows=376,509 width=16) (actual time=0.045..35,323.846 rows=378,859 loops=1)

  • Filter: (list = 1)
11. 0.031 0.081 ↓ 2.0 20 1

Hash (cost=1.20..1.20 rows=10 width=8) (actual time=0.081..0.081 rows=20 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
12. 0.050 0.050 ↓ 2.0 20 1

Seq Scan on ukrycie_na_liscie_spraw uls (cost=0.00..1.20 rows=10 width=8) (actual time=0.030..0.050 rows=20 loops=1)

  • Filter: (ghost IS NOT TRUE)
13. 0.001 0.002 ↓ 0.0 0 1

Hash (cost=20.20..20.20 rows=1,020 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
14. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on cust_not_to_zenmoney cntz (cost=0.00..20.20 rows=1,020 width=8) (actual time=0.001..0.001 rows=0 loops=1)