explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dimN

Settings
# exclusive inclusive rows x rows loops node
1. 0.086 48,165.603 ↑ 1.0 100 1

Limit (cost=60,833.79..60,834.04 rows=100 width=499) (actual time=48,165.455..48,165.603 rows=100 loops=1)

2. 65.665 48,165.517 ↑ 530.1 100 1

Sort (cost=60,833.79..60,966.32 rows=53,014 width=499) (actual time=48,165.454..48,165.517 rows=100 loops=1)

  • Sort Key: (date_part('epoch'::text, qc.created_at)) DESC
  • Sort Method: top-N heapsort Memory: 126kB
3. 47,842.294 48,099.852 ↓ 1.2 63,891 1

Hash Left Join (cost=14,615.15..58,807.63 rows=53,014 width=499) (actual time=129.618..48,099.852 rows=63,891 loops=1)

  • Hash Cond: (qc.operation_id = ar.operation_id)
4. 128.992 128.992 ↓ 1.2 63,891 1

Seq Scan on queue_client qc (cost=0.00..33,001.12 rows=53,014 width=455) (actual time=0.011..128.992 rows=63,891 loops=1)

  • Filter: (is_primary AND ((intent)::text = ANY ('{translate,xliff}'::text[])) AND (client_id = '96673b0d-f5a5-4857-a9e1-91f33cf668ec'::text) AND (created_at >= ((now())::date - '30 days'::interval)))
  • Rows Removed by Filter: 7970
5. 65.612 128.566 ↓ 1.0 66,485 1

Hash (cost=10,294.29..10,294.29 rows=66,229 width=401) (actual time=128.565..128.566 rows=66,485 loops=1)

  • Buckets: 16384 Batches: 8 Memory Usage: 3671kB
6. 62.954 62.954 ↓ 1.0 66,485 1

Seq Scan on async_tasks_results ar (cost=0.00..10,294.29 rows=66,229 width=401) (actual time=0.003..62.954 rows=66,485 loops=1)

Planning time : 0.341 ms
Execution time : 48,165.708 ms