explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2iYF

Settings
# exclusive inclusive rows x rows loops node
1. 1.863 187.019 ↓ 1.0 793 1

Hash Join (cost=324.22..597.87 rows=777 width=4) (actual time=186.601..187.019 rows=793 loops=1)

  • Hash Cond: ("J_msrrvsnii".info = "J_ccdainfo".info)
2. 3.025 158.466 ↑ 1.0 14,488 1

Bitmap Heap Scan on "J_msrrvsnii" (cost=81.34..292.89 rows=14,488 width=4) (actual time=155.516..158.466 rows=14,488 loops=1)

  • Filter: ("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone)
  • Heap Blocks: exact=121
3. 155.441 155.441 ↓ 2.0 14,488 1

Bitmap Index Scan on optimize8 (cost=0.00..77.72 rows=7,244 width=0) (actual time=155.441..155.441 rows=14,488 loops=1)

  • Index Cond: (("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone) = true)
4. 0.146 26.690 ↑ 1.0 806 1

Hash (cost=232.57..232.57 rows=825 width=4) (actual time=26.690..26.690 rows=806 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
5. 26.544 26.544 ↑ 1.0 806 1

Index Only Scan using optimize9 on "J_ccdainfo" (cost=0.29..232.57 rows=825 width=4) (actual time=11.473..26.544 rows=806 loops=1)

  • Index Cond: (("erasedAt" >= '9999-12-31 00:00:00'::timestamp without time zone) AND (ccda = 88))
  • Heap Fetches: 98
Planning time : 10.712 ms
Execution time : 187.091 ms