explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2F0S

Settings
# exclusive inclusive rows x rows loops node
1. 7.556 26.070 ↑ 2.2 1,624 1

Gather (cost=1,000.42..6,128.86 rows=3,565 width=113) (actual time=0.980..26.070 rows=1,624 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 7.155 18.514 ↑ 2.6 812 2

Nested Loop (cost=0.42..4,772.36 rows=2,097 width=113) (actual time=0.091..18.514 rows=812 loops=2)

3. 11.351 11.351 ↑ 2.6 812 2

Parallel Seq Scan on ddocumento ddo (cost=0.00..2,297.63 rows=2,138 width=117) (actual time=0.028..11.351 rows=812 loops=2)

  • Filter: ((NOT ddo_cancelado) AND (ddo_transacc = 1))
  • Rows Removed by Filter: 27056
4. 0.008 0.008 ↑ 1.0 1 1,624

Index Scan using pk_ccomproba on ccomproba ccm (cost=0.42..1.16 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=1,624)

  • Index Cond: (ccm_id = ddo.ccm_id)
  • Filter: (ccm_estado = 2)
Planning time : 0.941 ms