explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WBeJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 4,576.797 ↓ 0.0 0 1

Merge Join (cost=3,631.33..3,640.62 rows=349 width=92) (actual time=4,576.797..4,576.797 rows=0 loops=1)

  • Merge Cond: (((thes_pvk.kodstm)::text = (thes_sdla.kodstm)::text) AND ((thes_pvk.period)::text = (thes_sdla.period)::text))
2.          

Initplan (for Merge Join)

3. 0.025 0.025 ↑ 1.0 1 1

Seq Scan on t3_tax_object_vehicle (cost=0.00..3.83 rows=1 width=17) (actual time=0.010..0.025 rows=1 loops=1)

  • Filter: ((vehicle_relation_id)::text = 'f15bbac5-37e7-455e-847d-682017220000'::text)
  • Rows Removed by Filter: 65
4. 0.509 0.570 ↑ 201.0 1 1

Sort (cost=14.70..15.20 rows=201 width=64) (actual time=0.570..0.570 rows=1 loops=1)

  • Sort Key: thes_pvk.kodstm, thes_pvk.period
  • Sort Method: quicksort Memory: 48kB
5. 0.061 0.061 ↑ 1.0 201 1

Seq Scan on thes_pvk (cost=0.00..7.01 rows=201 width=64) (actual time=0.013..0.061 rows=201 loops=1)

6. 0.006 4,576.224 ↓ 0.0 0 1

Sort (cost=3,612.81..3,613.95 rows=456 width=8) (actual time=4,576.224..4,576.224 rows=0 loops=1)

  • Sort Key: thes_sdla.kodstm, thes_sdla.period
  • Sort Method: quicksort Memory: 25kB
7. 4,576.218 4,576.218 ↓ 0.0 0 1

Seq Scan on thes_sdla (cost=0.00..3,592.67 rows=456 width=8) (actual time=4,576.218..4,576.218 rows=0 loops=1)

  • Filter: (($0)::text ~ replace(((svin)::text || '$'::text), '?'::text, '.'::text))
  • Rows Removed by Filter: 91124
Planning time : 0.519 ms
Execution time : 4,576.840 ms