explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XhvN

Settings
# exclusive inclusive rows x rows loops node
1. 167.380 329.768 ↓ 1.0 690,367 1

Nested Loop (cost=12,738.15..109,223.54 rows=680,461 width=371) (actual time=74.254..329.768 rows=690,367 loops=1)

2. 0.018 0.018 ↑ 1.0 1 1

Index Scan using arretipo_tipo_pk on arretipo (cost=0.14..8.16 rows=1 width=323) (actual time=0.016..0.018 rows=1 loops=1)

  • Index Cond: (k00_tipo = 5)
3. 92.384 162.370 ↓ 1.0 690,367 1

Bitmap Heap Scan on arrecad (cost=12,738.01..102,410.77 rows=680,461 width=52) (actual time=74.232..162.370 rows=690,367 loops=1)

  • Recheck Cond: (k00_tipo = 5)
  • Heap Blocks: exact=18380
4. 69.986 69.986 ↓ 1.0 690,367 1

Bitmap Index Scan on arrecad_tipo_in (cost=0.00..12,567.89 rows=680,461 width=0) (actual time=69.986..69.986 rows=690,367 loops=1)

  • Index Cond: (k00_tipo = 5)
Planning time : 0.242 ms
Execution time : 351.266 ms