explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1PXC

Settings
# exclusive inclusive rows x rows loops node
1. 776.914 13,347.340 ↓ 82.0 82 1

Hash Join (cost=497.74..643.77 rows=1 width=295) (actual time=9,988.047..13,347.340 rows=82 loops=1)

  • Hash Cond: (a._idrref = a2._document185_idrref)
2. 5,720.462 5,720.462 ↓ 571.5 362,929 1

Foreign Scan on _document185 a (cost=100.00..243.35 rows=635 width=105) (actual time=6.325..5,720.462 rows=362,929 loops=1)

3. 0.453 6,849.964 ↓ 82.0 82 1

Hash (cost=397.64..397.64 rows=1 width=239) (actual time=6,849.964..6,849.964 rows=82 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 21kB
4. 765.228 6,849.511 ↓ 82.0 82 1

Hash Join (cost=314.01..397.64 rows=1 width=239) (actual time=3,205.657..6,849.511 rows=82 loops=1)

  • Hash Cond: (a2._document185_idrref = a3.act)
5. 6,082.352 6,082.352 ↓ 1,067.8 367,338 1

Foreign Scan on _document185_vt547 a2 (cost=100.00..182.24 rows=344 width=214) (actual time=3.945..6,082.352 rows=367,338 loops=1)

6. 0.254 1.931 ↑ 1.0 82 1

Hash (cost=205.60..205.60 rows=82 width=25) (actual time=1.931..1.931 rows=82 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
7. 1.677 1.677 ↑ 1.0 82 1

Index Scan using apteka_acts_nsdl on apteka_acts a3 (cost=0.42..205.60 rows=82 width=25) (actual time=0.296..1.677 rows=82 loops=1)

  • Index Cond: (nsdl = ANY ('{3527740,3528041,3528042,3533234,3533235,3533236,3533237,3533238,3533239,3533240,3533241,3533242,3533243,3
Planning time : 8.677 ms
Execution time : 13,371.220 ms