explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ggh1

Settings
# exclusive inclusive rows x rows loops node
1. 0.040 1.353 ↑ 1.0 1 1

GroupAggregate (cost=904.29..905.02 rows=1 width=54) (actual time=1.353..1.353 rows=1 loops=1)

  • Group Key: u.title
2. 0.061 1.313 ↑ 1.1 86 1

Sort (cost=904.29..904.53 rows=96 width=46) (actual time=1.299..1.313 rows=86 loops=1)

  • Sort Key: u.title
  • Sort Method: quicksort Memory: 31kB
3. 0.032 1.252 ↑ 1.1 86 1

Nested Loop (cost=20.07..901.13 rows=96 width=46) (actual time=0.328..1.252 rows=86 loops=1)

4. 0.036 0.036 ↑ 1.0 1 1

Seq Scan on ""user"" u (cost=0.00..3.59 rows=1 width=46) (actual time=0.019..0.036 rows=1 loops=1)

  • Filter: (id = 1,658,881)
  • Rows Removed by Filter: 47
5. 1.024 1.184 ↑ 1.1 86 1

Bitmap Heap Scan on req_package2 rp (cost=20.07..896.58 rows=96 width=0) (actual time=0.302..1.184 rows=86 loops=1)

  • Recheck Cond: ((apply_time)::date = '2020-07-03'::date)
  • Filter: ((state = 3) AND (fin_item_id = 143,899))
  • Rows Removed by Filter: 415
  • Heap Blocks: exact=196
6. 0.160 0.160 ↓ 1.6 788 1

Bitmap Index Scan on aix_5424099e825293b0f339b8d3abfb388e (cost=0.00..20.05 rows=501 width=0) (actual time=0.160..0.160 rows=788 loops=1)

  • Index Cond: ((apply_time)::date = '2020-07-03'::date)
Planning time : 0.426 ms
Execution time : 1.438 ms