explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JxYL

Settings
# exclusive inclusive rows x rows loops node
1. 259.107 1,510.980 ↓ 146.2 353,558 1

Gather (cost=1,000.84..368,972.42 rows=2,418 width=3,460) (actual time=1.285..1,510.980 rows=353,558 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
2. 50.597 1,251.873 ↓ 121.7 58,926 6 / 6

Nested Loop (cost=0.84..367,670.17 rows=484 width=3,240) (actual time=70.061..1,251.873 rows=58,926 loops=6)

3. 904.018 904.018 ↓ 122.8 59,452 6 / 6

Parallel Index Scan using i_docdeu_nit on docdeu (cost=0.42..366,836.85 rows=484 width=3,248) (actual time=69.938..904.018 rows=59,452 loops=6)

  • Filter: (estado = 'A'::bpchar)
  • Rows Removed by Filter: 21,133
4. 297.258 297.258 ↑ 1.0 1 356,710 / 6

Index Only Scan using nits_nit on nits (cost=0.42..1.72 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=356,710)

  • Index Cond: (nit = docdeu.nit)
  • Heap Fetches: 353,558
Planning time : 2.678 ms
Execution time : 1,538.949 ms