explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0zb

Settings
# exclusive inclusive rows x rows loops node
1. 1,512.301 2,948.824 ↑ 120.8 200 1

Hash Left Join (cost=50,010.11..127,951.08 rows=24,150 width=40) (actual time=819.714..2,948.824 rows=200 loops=1)

  • Hash Cond: (tp.id_trasy = t.id_trasy)
  • Filter: (((t.data > (('now'::cstring)::date - 400)) AND ((m.flaga & 2) > 0)) OR ((tp.id_ph = 276) AND (tp.flaga = 16)))
  • Rows Removed by Filter: 1,156,862
2. 625.696 1,389.626 ↑ 1.0 1,157,062 1

Hash Right Join (cost=46,970.98..86,067.77 rows=1,166,177 width=44) (actual time=767.165..1,389.626 rows=1,157,062 loops=1)

  • Hash Cond: (m.id_pd = tp.id_pd)
3. 0.601 0.601 ↓ 0.0 0 1

Seq Scan on m_asm_pd m (cost=0.00..182.18 rows=11,118 width=8) (actual time=0.601..0.601 rows=0 loops=1)

4. 412.183 763.329 ↑ 1.0 1,157,062 1

Hash (cost=23,282.77..23,282.77 rows=1,166,177 width=40) (actual time=763.329..763.329 rows=1,157,062 loops=1)

  • Buckets: 1,048,576 Batches: 2 Memory Usage: 45,425kB
5. 351.146 351.146 ↑ 1.0 1,157,062 1

Seq Scan on trasowki_pd tp (cost=0.00..23,282.77 rows=1,166,177 width=40) (actual time=0.025..351.146 rows=1,157,062 loops=1)

6. 23.014 46.897 ↑ 1.0 97,222 1

Hash (cost=1,798.50..1,798.50 rows=99,250 width=8) (actual time=46.897..46.897 rows=97,222 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 4,803kB
7. 23.883 23.883 ↑ 1.0 97,222 1

Seq Scan on trasowki t (cost=0.00..1,798.50 rows=99,250 width=8) (actual time=0.011..23.883 rows=97,222 loops=1)