explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AWn

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 27,784.611 ↑ 1.0 1 1

Aggregate (cost=221,096.26..221,096.27 rows=1 width=8) (actual time=27,784.610..27,784.611 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=132352 read=132373
2. 0.002 27,784.606 ↓ 0.0 0 1

Nested Loop (cost=0.42..221,095.98 rows=115 width=0) (actual time=27,784.606..27,784.606 rows=0 loops=1)

  • Buffers: shared hit=132352 read=132373
3. 33.850 33.850 ↑ 1.0 1 1

Index Only Scan using task_pkey on f211507244dc4408a9808b5ad90bbe12.task task1 (cost=0.42..2.44 rows=1 width=4) (actual time=33.846..33.850 rows=1 loops=1)

  • Output: task1.id
  • Index Cond: (task1.id = 398738)
  • Heap Fetches: 1
  • Buffers: shared read=4
4. 27,750.754 27,750.754 ↓ 0.0 0 1

Seq Scan on f211507244dc4408a9808b5ad90bbe12.billingitem2denormalizedmetadata lingitem2denormalizedmetadata0 (cost=0.00..221,092.39 rows=115 width=4) (actual time=27,750.754..27,750.754 rows=0 loops=1)

  • Output: lingitem2denormalizedmetadata0.id, lingitem2denormalizedmetadata0.billingitemid, lingitem2denormalizedmetadata0.userid, lingitem2denormalizedmetadata0.projectid, lingitem2denormalizedmetadata0.taskid, lingitem2denormalizedmetadata0.activityid, lingitem2denormalizedmetadata0.billingrateid, lingitem2denormalizedmetadata0.timesheetid, lingitem2denormalizedmetadata0.billingtypeuri, lingitem2denormalizedmetadata0.expensetypeid, lingitem2denormalizedmetadata0.rate, lingitem2denormalizedmetadata0.clientid
  • Filter: (lingitem2denormalizedmetadata0.taskid = 398738)
  • Rows Removed by Filter: 7097871
  • Buffers: shared hit=132352 read=132369
Planning time : 522.046 ms
Execution time : 27,784.712 ms